how to read excel data into a dataset

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: DaberElay (DaberElay_at_discussions.microsoft.com)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 08:11:01 -0700

Hi,
while trying to load excel file with oledb connection, it seem to turn integer values in string fields into DbNull, i also tried copy & paste with the clipboard and the CSV but i cant find any tool that would parse the data back into a dataset / table

is there a solution out there ?
thanks.