Pull Data from Excel

[wtrimble]

This question is in relation to the last question I had. Can I pull data from Excel for an Update Query in Access?

 

[Trevor G]

See my reply to your first thread.

If you want to do this from Excel then use the Data Tab or menu. There is a guide.

 

[wtrimble]

Yes I believe that is to pull a query from Access into Excel. I want to use an Update Query in Access and call upon an excel file /sheet/range... any idea?

 

[chergh]

Create a named range in your excel file and then add it as a linked table into access.

 

[Trevor G]

As suggested you can connect to a Access database via either the Data Menu or Data tab depending on which version of MS Office you are using.

If you are needing this to be linked then when the data comes in it should provide you with a refresh option so updated data goes back to the database.

Please state which verison of MS Office you are using you will get better guidance.

 

[wtrimble]

I'm using 2007