Exporting

[SpiderBear6]

I have a table with over 100,000 records in it and I need to export it to a comma-delimited text file. I have tried using the Export menu item when you right click the table name but I get an "Invalid Argument" error when I click on the Finish button. I suspect that it's because of the number of records. How else can I get this table into a comma-delimited text file?

Please help me...

 

[SpiderBear6]

I think I found a way. If I import the tables into a SQL Server database and then open the sql server database from access 2000, it lets me export the larger tables.

Excellent.. I didn't want to have to write an app just to export some tables as comma-delimited files.