Hi, I have a large file with over

[lavaghman]

Hi,
I have a large file with over 1 million records in both txt and dbf format. The file was exported from a FoxPro table. I need to query this data to pull off about 20,000 records.
I only have MSAccess on my current machine and when I attempt to open the dbf file with Access it takes ages and doesn't pull in the whole file. Any ideas how i can somehow query the dbf file or txt file to get the records i need? Will I need to install another DBMS? Do I need to get my hands on FoxPro itself?

Any help greatly appreciated, thanks,
Lavaghman

 

[psemianonymous]

Consider fully importing the data into your Access MDB, thus speeding up your execution time. This way you can index fields and use other benefits of the JET engine. The tradeoff is of course, the time it takes to import the data and the storage space used up by Access for the data (considerable). For this you get very speedy results.


Also check your query: things like "Name = 'John Doe'" run much faster than using "Name LIKE 'John Doe'", and if you index the "Name" field, the first statement will run an order faster (minutes->seconds).

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[lavaghman]

Thanks for the reply. I see what you mean about the time issue but I don't know how I can get all the DBF file to load into Access in the first place, since only some of it is loading at the moment??? I really don't mind if I have to leave the query running for ages. Also, what is a jet engine?
Thanks again,
Lavaghman