Import from Excel

[Amy]

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

 

[Tim Williams]

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

Tim.

 

[Amy]

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

 

[Guest]

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]

What does your code look like?

Tim

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

 

[Guest]

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]

http://blogs.acceleration.net/ryan/archive/2005/01/11/477.aspx

Tim

 

[Guest]

Thanks Tim.

http://blogs.acceleration.net/ryan/archive/2005/01/11/477.aspx

Tim