Excel

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[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

 

[Guest]

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

If the option is not there, it sounds like your access installation is not complete,
you will probably have to re-install access unless someone posts a simpler sollution.

gm

 

[Guest]

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

FYI, when you do get this working, if you want the file to automatically open in
excel upon the transfer, look at the autostart option....
gm

 

[Guest]

Hi all

Got it working - thanks for the help much appreciated

cheers Rexmann