import a large ammount of records into access 2002

D

david

I am trying to import about 240M of text records into a DB
created in Access 2000, using Access 2002. When I do I
get an error that says to the effect that I am out of Disk
space. I have updated my MDACs and Jet 4.0 drivers but
continue to get the error. Anyone who has seen this
problem please help. Thanks
David D.
 
S

Sylvain Lafontaine

It's possible that the database must be compacted or that you are really out
of Disk space.

Also, Access 2000/2 use the Unicode format for text records, doubling the
required size. Retry after setting the Unicode compression option for your
text fields.

S. L.
 

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

Importing FoxPro 2.6 DBF Into Access 2007 1
Import Excel 2010 table into Access 2010 - not listed as range 0
Using TransferSpreadsheet to import from Excel to Access with variable file names 1
error 3709 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
import and other problems 0
Error importing from Excel 1
Import / link table to large .csv file 8

Top