I have an ASP.NET (VB) routine that imports a lot of data from an Excel

spreadsheet
into a OleDbDataAdapter, and then into a database table. The import
has been working fine until now, but my latest spreadsheet has a column

that can be either completely numeric or alphanumeric. As long as the
first row contains alphanumeric everything is fine, but the latest
spreadsheet I received contained completely numeric data in the first
10 rows. This caused some of the alphanumeric data to not be read in.
I have been using IMEX=1 in my connection string which fixed this type
of situation I had when I first started working on this project, but it

doesn't seem to be working on this particular field.


Any suggestions?


Thanks,
Amy Bolden

Hi Amy,

You may want to try microsoft.public.dotnet.languages.vb

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Amy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have an ASP.NET (VB) routine that imports a lot of data from an Excel
>
> spreadsheet
> into a OleDbDataAdapter, and then into a database table. The import
> has been working fine until now, but my latest spreadsheet has a column
>
> that can be either completely numeric or alphanumeric. As long as the
> first row contains alphanumeric everything is fine, but the latest
> spreadsheet I received contained completely numeric data in the first
> 10 rows. This caused some of the alphanumeric data to not be read in.
> I have been using IMEX=1 in my connection string which fixed this type
> of situation I had when I first started working on this project, but it
>
> doesn't seem to be working on this particular field.
>
>
> Any suggestions?
>
>
> Thanks,
> Amy Bolden
>

I was able to solve my problem by putting HDR=No in the connection
string. Then I insert the header text as the first record for the
field, thereby forcing Excel to make the field a string. This seems to
work well, although it is a little goofy.
Thanks,
Amy