Thanks for the response Tim.
I used IMEX=1 in the connection string and it started working.
Can you tell me what is the significance of that particular attribute.

Thank You,
Pradeep


"Tim Williams" wrote:

What does your code look like?

Tim


"Pradeep S" wrote in message ...
Hello Tim,

I have the same problem.

Can you tell me how to cast the problem field to text.
My excel sheet does not contain any headers.

Thanks,
Pradeep

"Tim Williams" wrote:

Have you tried concerting/casting the problem field to text in the query?

Tim.


"Amy" wrote in message
oups.com...
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