Importing from Excel

A

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing from Excel 4
Import from Excel 2
Import from Excel 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Returning Values from a Table 5
Tying to extract all data from a pivot pulling from external data 3
Extracting 7 digit number from alphanumeric string 10
Importing Text Fields in Excel 2

Top