Link to access table....
Posted by Laurinda on January 02, 2001 5:52 AM
I am trying to pull data into an excel spreadsheet and will have to do this every two hours or so. I want to be able to have a worksheet already set so that when the data in the access table changes I will be able to see it in the excel worksheet. If I can link that is fine or if there is a way to run vba code that will allow me to import the data that would work too. I am just not sure how to do either...I am not used to working with Excel...any help is greatly appreciated. Thanks
Posted by JAF on January 02, 2001 6:37 AM
Go to the Data menu, select Get External Data, select New Database Query, select MS Access Database (use the Help facility of necessary).
This will pull in to Excel the data you specify from the Access database. To refresh the spreadsheet to reflect changes in Access, right click the query and select Refresh Data.
You can if necessary set up a macro to refresh this at specified time intervals if necessary, but the manual option should suffice. If you need more info, please post back.
JAF
Posted by Laurinda on January 02, 2001 7:46 AM
Do you know if there is a way to run these queries in code? in sql? and still be able to get to the information in access? Another question that is somewhat related --- I know how to name different ranges on a single worksheet, is it possible to bring information into these specific ranges?
