URGENT for users who import large data files into MS ACCESS 2007 data base.

Microsoft admits a problem, "Access 2007 takes more time to import large [30 megabyte] .csv files than Access 2003 does," but claims slow import is fixed in MS Office 2007 Service Pack 1 (SP1).

Do you have/need MS Office Service Pack 1 (SP1)?

In MS Access 2007 it is not just "Help/About" anymore....

If you are in MS Access 2007:

1. Click the Microsoft Office Button (round icon upper left corner), and then click Access Options (lower right corner).

2. Click Resources (last item of list), and then click About (last item of list).

3. Check for Updates button (upper right) or Get Updates (top of list)



The slow CSV import issue is one of many listed in Microsoft Knowledge Base article kb 942378.
http://support.microsoft.com/kb/942378

QUOTE from Microsoft kb 942378

"The 2007 Microsoft Office suites SP1 [Service Pack 1]
* * *
also fixes the following issues that were not previously documented in a Microsoft Knowledge Base article:
* * *
Access 2007 takes more time to import large .csv files than Access 2003 does

When you try to import a large .CSV file, such as a file that is larger than 30 megabytes (MB),
Access 2007 appears to stop responding at the import dialog box.

After several moments, you may receive the following error message:

File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry

When you click OK to close the error message, you can usually finish the import process. All records are imported successfully."

http://support.microsoft.com/kb/942378


====
The slow CSV/TSV import issue has been encountered by the Orange County DEC IT Committee.

Documented by Jim Callahan
on behalf of
Orange County DEC Information Technology (IT) Committee, Doug De Clue, Chair