Changing data types in a column. Numeric to Alphanumeric

I'm trying to read in a .csv file and I'm running into a problem where the "type" of data changes in a column, so most of the data is numeric, but then some values are text.
For example:
LocationCode
1
2
50
4
2
1
33
33A

I added the IMEX=1

Data Source='C:\ADPLink';Extended Properties = 'text;HDR=YES;FMT=CSVDelimited;IMEX=1'

The program reads in the data, no errors, but on the records that are alphanumeric, it doesn't bring in the value for that column.
This if for a legacy ClassicASP web application and it's using ACE.OLEDB.12.0

Any guidance would be greatly appreciated.

0
edit delete
are you sure?
asked Brian Fasano

0 answers

Post an answer but please log in first

Post Answer
  1. Please log in to post answer

Similar Questions

Tagsfor this question

Forumall questions