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

Similar Threads

Access MaxLocksPerFile error Windows 10 - Access 2013 0
Import from Notepad delimited text 7
Importing Text Files Into Access 1
File sharing lock count exceeded. Increase MaxLocksPerFile registry 4
Access 2003: Import Extensionless Files 3
Importing large ascii file into access 4
Import and Append of txt files 1
Trouble Importing text file into Access 2007 1

Back
Top