Excel

R

rexmann

Hi all

I have been trying to send an access table to excel. I right click the table
and select export and then change the details to xls and save. However on
opening the file it appears to be empty apart from the headings. I have tried
saving as a text file but still no joy. I know I could just cut and paste but
I would like to know how to do this.

Any help greatly appreciated.

Rexmann
 
C

colin

Hi

If you open the table and then go to tools and click on Analyze with excel.

you can also set up a macro to output a table to excel
 
R

rexmann

Hi Colin

thanks for the advice but under tools and analyse I do not have analyse with
excel. I do have analyse but no option for excel is listed. Is it an addin?
any help appreciated

cheers Rexmann
 
A

Arvin Meyer

It should be part of the full Office installation. Make sure that you have
the table you want to export selected and in sight in the database window.
You can also build a macro using either the OutputTo or the
TransferSpreadsheet actions, and specifically name the sheet and Excel book
(file).
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top