export to Excel and CSV formats at "touch of a button"?

  • Thread starter Thread starter tradmusic
  • Start date Start date
T

tradmusic

Hi,

Is there a macro or something I can use, in Access, that will allow me to
create a button, within a form, that when clicked, saves the entire table as
both Excel and CSV formats on the users machine?

Any help would be greatly appreciated. Thanks.
Nath.
 
Terrific MStrider - although I'm a relatively newbie at Access.

Surprised that there isn't some way of setting up an automatic export -
seems an obvious "useful" feature if you ask me.

If you don't mind sharing the code, that would be great, thanks.
Nath.
 
Yes. Create a macro with 2 seperate actions: TransferSpreadsheet and
TransferText. Set the options for each, such as file name, location, etc.
Then create a button that runs the macro in the OnClick event.

Not sure how new to Access you are, but I can send you an mdb file with an
example if you need it. Took about 3 minutes to set up.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Hi Kevin,

Yes, if you can send me that mdb file to have a look at, great!
Thanks very much for your help.
Regards
Nath.

MStrider...hold with that code!
 
Back
Top