RE: Using Jet to read excel file returns blank for last cell - som

From: Ron (bapa118_at_online.nospam)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 06:31:02 -0800

This is exactly what I did yesterday - make the SQL datatype varchar. The
code I posted is used to import the layout, the actual data is imported at a
later stage and I had to switch that to varchar a long time ago. I did not
switch the data type for the layout though. I had it set as text actually
and I know that is not good. Hopefully switching to varchar will fix the
problem.

thanks,

ron

""Peter Huang" [MSFT]" wrote:

> Hi
>
> The test *** did not display correct in the web, I think you may try to
> post the excel file and your vb6 project files as a zip file and then post
> in the newsgroup as attachment.(You may also try in the Outlook express)
>
> Also you may try to email to me directly by removing the "online" from my
> email address.
>
> Based on my test so far, your code seems ok.(I tested with other sample
> data)
> I guess you may try check if the datatype is compatible between the sql and
> excel file.
> What did you declare the according datatype in the SQL server?
> You may try to declare all as varchar to see if it will help.
>
> Also for ADO problem you may also try to post in the newsgroup below to
> seek ADO expert for help.
> microsoft.public.ado
>
> Best regards,
>
> Perter Huang
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>