Updating Multiple Excel Worksheets from Access Database

[Guest]

I would like to automate the process of updating price lists created in
Excel. I have price lists that are in US and Euros and that are for different
groups. My goal is to update from only one source instead of going to every
single Excel worksheet. Can this be done from Access? I need a more efficient
way to update these lists.

 

[Larry Linson]

I would like to automate the process of updating price lists created in
Excel. I have price lists that are in US and Euros and that are for
different
groups. My goal is to update from only one source instead of going to
every
single Excel worksheet. Can this be done from Access? I need a more
efficient
way to update these lists.

In the past, you could link Excel spreadsheets and update them in place; due
to a patent lawsuit, Microsoft has disabled this capability in some versions
of Access. You can still, from Excel, obtain data from an Access database
via MS Query, or, from Access, you can still export to Excel.

With no more detailed information than you provided, I don't think anyone
here can be much more specific on how to handle this. But, if you can
provide some clarification and detail, perhaps someone can offer more
specific suggestions.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for your response Larry. I am going to post in the Excel forum for
additional help. I think Excel may be the answer for me.