Are there any useful database table exporting programs for Access?

[Grant Palin]

I need to export an Access table into a text file...are there any programs useful for this purpose? I tried exporting the table right from Access, but it seems to be limited to about 65000 records...the table has over 1.6 million records!

[Roy Sinclair]

Any Access database with 1.65 million records in a table desperately needs to be upsized to a proper database product.

That said, it shouldn't be too hard to write a VBScript to use ADO to read the database (format the columns as desired in your select statement) and the GetRows method to reap an array which can be streamed out to a text file. Basically you'd do it almost exactly the same as if it were in an ASP page.

[Grant Palin]

It's not my database. I'm doing this for someone else.

I don't think I should need to do this through VBScript...the database isn't being used online or anything. The person who got me to do this wants to be able to import the text file version of the DB into another DB such as DBase.

In any case, I'd done some more tinkering around since I first posted, and found that I could export the table as multiple formatted text files. I set up a query string to remove the formatting, leaving me with the raw data.

[raf]

I've frequently used

http://www.intranet2internet.com/public/default.asp

free, extremely simple and fast enough.
Now, i've only used it on relatively saal table. Biggest being 50k records, because i only used MsAccess for smaal projects or tryouts.

What it does is create a dumpfile --> a textfile containing all sql-statements you need to recreate the db (if choosen), table (if choosen) and insert all records. Just like the mySQL dumpfiles.
You can then run this file to recreate your table in almost any other db-server like mySQL, MsServer etc.

[Grant Palin]

Thanks for that idea raf, but I managed to do the exporting on my own...Just had to export to a text file and remove the formatting to leave the raw data. Thanks anyway!