how to read excel data into a dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,

Check this messages from Paul Clement, he has so much written about this in
the dotnet newsgroups the last times, one of your problems should be there.

http://tinyurl.com/5gc87

I hope this helps?

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to dataset (Read Column properties) 0
reading text file using OLEDB into dataset 5
OleDb can't read Excel file? 4
Export Excel data into a dataset 2
Any way to make OleDb read an Excel file? 24
Reading Excel into a dataset 4
null value in xml translates to empty string in dataset after ReadXML 1
How to read a Xml string into dataSet 1

Back
Top