M
Marlita
I have looked at all the other posts but I just need to know how to export a
simple table, as it is, to Excel.
Please help.
Thank you
simple table, as it is, to Excel.
Please help.
Thank you
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom van Stiphout
On Wed, 28 Jan 2009 20:32:01 -0800, Marlita
Look in the help file: DoCmd.TransferSpreadsheet
-Tom.
Microsoft Access MVP
Look in the help file: DoCmd.TransferSpreadsheet
-Tom.
Microsoft Access MVP
M
Maarkr
-or- you can try to build a macro... may be easier if you're new... Select
macro...New... Action= TransferSpreadsheet, Transfer type = Export,
SSType=MS Excel, Enter the table name, file name. Macros may be easier for
many people since Access takes care of the formatting for you.
macro...New... Action= TransferSpreadsheet, Transfer type = Export,
SSType=MS Excel, Enter the table name, file name. Macros may be easier for
many people since Access takes care of the formatting for you.
M
Marlita
Hi Maarkr. That worked!!! I love this site. Thank you! Is there a place
that explains the different macro possibilities, what they do, how to build
them?
Marlita
that explains the different macro possibilities, what they do, how to build
them?
Marlita
M
Marlita
Hi Tom. Thank you for responding.
I will try this.
Marlita
I will try this.
Marlita
M
Maarkr
search the web for examples... there's this...
http://msdn.microsoft.com/en-us/library/bb258199.aspx
It takes a while to learn... select the Macro objects, New, and look at the
Actions column to select a macro, then look at the bottom of the page for the
arguments. Use F1 with an item highlighted to get Access help.
Pls select 'Yes' at the bottom of any posts that are helpful to you.
http://msdn.microsoft.com/en-us/library/bb258199.aspx
It takes a while to learn... select the Macro objects, New, and look at the
Actions column to select a macro, then look at the bottom of the page for the
arguments. Use F1 with an item highlighted to get Access help.
Pls select 'Yes' at the bottom of any posts that are helpful to you.
A
ANA Y VICKY
Maarkr said:search the web for examples... there's this...
http://msdn.microsoft.com/en-us/library/bb258199.aspx
It takes a while to learn... select the Macro objects, New, and look at
the
Actions column to select a macro, then look at the bottom of the page for
the
arguments. Use F1 with an item highlighted to get Access help.
Pls select 'Yes' at the bottom of any posts that are helpful to you.