By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,591 Members | 629 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,591 IT Pros & Developers. It's quick & easy.

Importing data performance

P: n/a
HELP! I don't know what happened. I have an MS_Access 2000 application
that imports 20 data files; some Excel, some fixed-length txt and some
tab delimited.
I use "DoCmd.TransferSpreadsheet . . .", "DoCmd.TransferText
acImportFixed, . . ." and "DoCmd.TransferText acImportDelim, . . ." to
import the data into the database.
I have created import specifications for all the versions of the data
files and the import for all 20 files used to take about 11 seconds.
I haven't touched the import code, but something happened and now it
takes 3-5 minutes.
I have checked and rechecked all the logical things: Defragged the hard
drive, no network involved, Compacted and Repaired the db, no
extraneous programs running, and it is still slow as molasses.
The import data files haven't changed either.
The only thing I did was delete the table relationships, because they
were hindering my file manipulations using VBA.

Any suggestions?
Thanks in advance.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.