export Ms Access 2000 table to new Ms Excel document

[Guest_imported]

Hello,

How can i export, access table to new excel document?

 

[p27br]

hello

use the transferspreadsheet method :

docmd.Transferspreadsheet acExport,acSpreadsheetTypeExcel9,tablename,filename

 

[Guest_imported]

isn't there another way, that file would not be saved automatically.. only would be opened excel window and writed in it table tada

 

[ETID]

You would not need to export the data to excel, (too many steps)...

Create a live link to the table or query from within excel,

From excel click Data>Get External Data>New Database

Query>....the choose msaccess databases* from the list...follow

the wizard from there (to select your mdb, table or query)
then return your data to excel.

You can opt to use the wizard or MsQuery (a gui type interface,

similar to access)at this point...
after your comfy with this...I would recommend the MsQuery

option.


when data is returned,...you can right click in the data and select

properties to refresh on open...auto fill formulas etc.

this is now a live link, any time the workbook is opened. your

current / up to date access data comes in (if you set the refresh on

open option)

 

[Guest_imported]

And how to do it automatically with vba. On button (which is in form) click will open excel document with ms access table data?

Thanx for help in advance..

 

[ETID]

No need for that....the spreadsheet is linked and can be set to update on opening of the spreadsheet


....right click in the "returned data" area of the spreadsheet to set that propertie.


any action taken in your database will be reflected when the sheet is open.