Exporting very large table to text

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

How can I export a very very big access 97 table (2 432 008 rows, 1 column) to text file? Here are numbers in format 000000000001, .....)

-- Anonymous, December 03, 2003

Answers

Anne,

In the Database window, click the name of the table or query you want to export, and then on the File menu, click Save As/Export.

In the Save Table dialog box, select Text Files in the 'Save as type:' box.

Hope this helps,

Eric

-- Anonymous, December 03, 2003


Moderation questions? read the FAQ