Hello,
I connect to an Excel file with ADO and I get the sheet names and after that I read the table. if the column is all integers or strings there's no problem but if the column is composed of integers and strings then only the strings are returned,others are returned empty.
What's the reason?
Thanks
Hi,did you try this here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q194124
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment