importing a text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to import a large txt file (360 megabytes) into my database.
About half way through loading the file access hangs. I have tried
increasing the size of MaxLocksPerFile, but it does not seem to help.

Any help would be appreciated.

Thanks

Neil
 
you should have caught the memo back in the year 2000 that MDB is
completely obsolete.


BULK INSERT can do this in SQL Server in about 1/10th the time as MDB

it's 100 times more powerful than your silly docmd.transfertext
 
Split the file into smaller chunks and append them to the same table. This
will narrow down the records to where the error is.

MH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top