asked on

Importing large text file to Access 2003 table

hi,

I am importing a large text file to a Access 2003 table. The file is 44,697kb and have probably 1.2 millions rows. It couldn't import succefully and it showed error message saying my computer is out of disk space. But the DB is on the D drive which has 61GB free space.

i really don't undersand. Please help.

thanks a lot.

kate

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

rockiroads

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kate_y

ASKER

but it said my computer is out space not the database. After i imported the partial (lost 18 records), the DB's size is 877,678kb. It is not close to 2GB yet.

rockiroads

No, its nothing to do with how much disk space u have, its limitations to do with Microsoft Access
I think if u try splitting that file, say in 2 or 3 parts, then try it, see what happens

kate_y

ASKER

ok. but how many rows can it store in one table? i read somewhere saying 100,000,000. is it tue

SOLUTION

prosh0t

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

kate_y

ASKER

yeah, you are right. i did the same thing. but when i run query to tables, it took forever to calculate the result.