Calling VBA gurus - need of Excel-Access interaction 1

[01491]

I'm trying to run an Access module from pressing a button in an Excel file. The module creates a table and then I need it to be exported to the excel file with the button.

Any help would be very appreciated!!!!

 

[ETID]

Look into an ODBC link for this....

from the menu in excel Data>Get Exernal data>New database query...choose "MSAccess database*", follow the wizard to return your data to excel.


Hint if you record this proceedur you can manipulate the SQL string created by this process (I.E. change parameters of the query) or assign a button to the process.

also if you right click on the returned data you can set properites to update on open, fill down formulas etc...