Excel OLEDB driver

[Administrator]

When using the Excel OLEDB driver to read some spreadsheets I created with XlsIO I occassionally had problems retrieving numeric data.

After following the advice in these 2 links everything cleared up. Hope this saves someone else a little time.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MySpreadsheet.xls;Extended Properties='Excel 8.0;HDR=YES;IMEX=1'

http://support.microsoft.com/kb/194124

http://www.connectionstrings.com/?carrier=excel

[Yavanaarasi G]

Hi George,

Thank you sharing your ideas.

Glad to hear that the problem has been solved.

Please let me know if you have any other concerns.

Regards,
G.Yavana