-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.
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?
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
