Deciding data type while importing data from CSV files in to Access

[raghavcacs]

Hi,

I have several CSV files i have to import in to Access and consolidate them in to Access. Few coloumns has numbers which are more than 16 digits. I want them to be uploaded in to access as text. Is there any way we can do this with the help of VBA?

 

[Joe4]

Is the question how to get those fields in Text instead of Numeric format? If go, VBA is not necessary. There are a few ways:

1. One way is to create a blank "shell" of table, where you have pre-defined all the field names and data types (where you can specify your data types). Then import that CSV file into that table shell.
2. The other way is to use the Import Wizard. and set the field-type to be Text in that. Right before you click "Finish", you can even save the Import Specification name, so you can re-use it with the other imports and not to have go through that whole process every time.