I'm using Docmd.transfertext to import in a .csv file. For one of my columns in the test csv file, the entries were S1, S2, S3, etc... After I imported the file into a database table, access converted this column of data into a currency field $1.00,$2.00,$3.00, etc... I didn't use a specification file in my docmd.transfertext command b/c I wanted to keep the column names flexible. After the file gets imported in, I have a subroutine to check for the existence of the correct field names. Is there a way to prevent Access from converting this text field to currency.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing csv to Access Table
- Thread starter iojbr
- Start date
dilettante
MIS
It sounds like you are asking about VBA, and if so you chose the wrong forum.
- Status
