Export to Excel

[Georges]

Hi,

Is it possible to export all the data of a table to a
Excel Sheet

Thanks

 

[losmac]

Yes, here is code:
http://www.losmac.republika.pl/access/access.html
click on link: Przykład 6

 

[Paul Falla]

IF it is a "one-off" export you require, and don't want to
get in to a hard coding solution, in the database window,
right click on the relevant table, and select "Export" and
then select where you want the table saved, and select the
type of file from the drop down list.

HTH

Paul