importing a text file

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
 
A

aaron.kempf

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
 
M

MH

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
Importing large ascii file into access 4
Trouble Importing text file into Access 2007 1
importing flat file 2
Changing Date format when Importing TXT file 2
How to replace a null column value in a fixed length text file 1
Importing Text File : Error "Field too Large" 4
Importing a text file - choosing where the fields end up 1

Top