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

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

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

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

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

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

Tim

"Pradeep S" wrote in message ...
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

Thanks Tim.

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

Tim

"Pradeep S" wrote in message ...
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