Importing Large Table Causes Disk Error

[DBFIN]

I am trying to import a cvs file that contains up to 2 million records and 36 fields. The software can't handle this size. I can quickly link to the file, but I must then append these records into another table so I can customize the field properties such as the primary key and indexes. If I append more than 50,000 records at a time, a disk error results.

Any suggestions on how I can quickly import these 2 million records in a table where I can edit the field properties ?

 

[KenHigg]

Can you append instead of import?

 

[DBFIN]

I've consulted with a co-worker who is an expert programmer. We tested linking to the cvs file and then appending 50,000 records at a time to a new table with an estimated completion time of 20 minutes. Maybe this is the only solution. I was hoping there was an easier method.

 

[KenHigg]

If you have an expert on site why are you posting questions here? (Just kiddin )

There still is no way it should take that long. Are you running the append from a csv file that is on a network server? If so maybe move it to the local machine first - ??

 

[DBFIN]

I am running from network server, I'll try running from local machine. Thank you most kindly sir.

 

[DBFIN]

I created a new table via an append query from the local machine, which took only 1 minute to process. I then linked to this new table from the network server, which also took less than a minute.

In summary, you offered the perfect solution. Thank you very kindly.

 

[KenHigg]

Cool - Glad you have it working.