How to change data type

  • Thread starter Thread starter apex77
  • Start date Start date
A

apex77

I am importing a csv file into an Access database< but need to change the
data types of several fields. Is there a way this can be done with a macro
and without having to go into design mode?
 
An alternative to simply accepting the structure and data types Access
assigns when you import a CSV file (or Excel spreadsheet, or ...) is to
treat what is imported as just the first step, and likely not
well-normalized data.

Spend some time laying out a more permanent, well-normalized table
structure. Then create a series of queries that will "parse" the raw import
data into their more appropriate and more permanent table structure.

You can create a macro that: imports the csv file, runs parsing query#1,
parsing query#2, ...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top