exporting query results to some type of file

S

SirPoonga

I have a query returning 25k+ records. I need to ouput the result to
either a tab/comma delimitted file or excel.

I tried copy and pasting the data into a spreadsheet, however that
crashed the computer.
 
M

Micah Chaney

Is there some reason why you don't utilize the Export feature within Access?
Open your Query to display the results. File Menu | Export. Select .txt in
the files as type box. Then follow the wizard to export as a tab delimited
text file. Does this help?
 
S

SirPoonga

That option is not available. THat's why I am asking.

I think I figured out a work around. I make my select query as nromal,
make sure I am getting the right data. Then change it to a make-table.
That will maek a table witht he result. Then I can export the table.
 
J

John Vinson

I have a query returning 25k+ records. I need to ouput the result to
either a tab/comma delimitted file or excel.

I tried copy and pasting the data into a spreadsheet, however that
crashed the computer.
Click to expand...

Open the Query. On the menu choose File... Export. Choose File Of Type
text or excel, whichever you like, and follow the prompts.

John W. Vinson[MVP]
 
S

SirPoonga

My Export menu option is greyed out. But just for that query. In some
others is isn;t greyed out.
 
Top