unable to import text file (1 Viewer)

[iworkonline]

Hi Guys

I am using Access2003 and trying to import a text file having 14,693,802 records. and I am getting a "Propert Not Found" error message.
I check the file and all the data is in the right format and also performed the Repair and compact.

Do you guys think by reading the file into a recordset and then writing the records into a new table will do the job?

Thanks.

 

[Vassago]

Hi Guys

I am using Access2003 and trying to import a text file having 14,693,802 records. and I am getting a "Propert Not Found" error message.
I check the file and all the data is in the right format and also performed the Repair and compact.

Do you guys think by reading the file into a recordset and then writing the records into a new table will do the job?

Thanks.

How large is this text file? How many fields? Access has a 2 GB limit on database size. "Property Not Found" is a very common error when the maximum size is reached.