-
Archives
-
Meta
Monthly Archives: October 2010
CSV Importing
The solution for importing a CSV file is to link to it instead of importing it. Linking to it, all the fields are correctly formatted and populated. One problem to watch out for; commas in the data. So I am … Continue reading
Posted in Access 2007 problems/solutions, Uncategorized
Tagged CSV Delimited Import XLS Excel Text
Comments Off on CSV Importing
Importing CSV files
Importing files can be tricky in MS Access. The application tries to set the property for each field and even with preset values you can still get data imported incorrectly. I don’t have a complete solution for this problem just … Continue reading
Posted in Access 2007 problems/solutions, Uncategorized
Tagged CSV, Import
Comments Off on Importing CSV files