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 | 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 , | Comments Off on Importing CSV files