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 "apex77" wrote in message news:D50F495D-60AB-4D2B-8537-975943FC2720@microsoft.com... >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?
