On Tue, 5 Oct 2004 08:19:01 -0700, "JASV" <JA**@discussions.microsoft.com> wrote:
¤ We are opening an excel file using a dataadapter object.
¤ The tables included in excel file are loaded into a dataset object.
¤ This process works correctly except for this issue:
¤
¤ There is an "Comment" field included in the excel sheet with 255 characters,
¤ but the dataset only read 64 characters.
¤
¤ Have any idea to solve this problem?
¤
Don't think I've seen this issue before unless the number of characters exceeds 255. Couple of
things to try. Assuming you're using the Jet OLEDB provider and Excel ISAM I would add the IMEX
argument to your connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\My Documents\Book2.xls;Extended Properties=""Excel 8.0; IMEX=1;"""
You may want to try changing the TypeGuessRows entry in the Registry as well:
http://support.microsoft.com/default...;EN-US;Q281517
Paul ~~~
pc******@ameritech.net
Microsoft MVP (Visual Basic)