Update Excel Database via Access Main Database with a script

  • Thread starter Thread starter Finnbar
  • Start date Start date
F

Finnbar

Hello, i am wondering about something fairly complex, i have two databases,
one in the access format (the most utilized one) and another one in excel
format, Since we use the Access one the most, but cannot print the
informations that it contains, i was forced to create a new one which you can
print off of, so here is the issue, whenever we add new information to the
access database, we need to manually update the excel one and it's very
unconvenient, because since we do not use it very often, it falls in the
depths of The Documents. My question to any expert out there is, Is there a
script that is made or can be made, that whenever new information is inputed
in the access file, automaticaly gets written to the excel database, like a
automator. Would that be something possbible to create? Or maybe, in all
better cases is already created?

Thanks alot, responses are appreciated.

Finn
 
Hi,

Create a live connection to Access from inside Excel. Choose Data, Import
External Data, New Database Query, choose MS Access Database and click OK.
Choose Get Data, and locate and select your access file. The wizard is
fairly self-explanitory. when you finish you will have you data in Excel and
anytime you want to reread the data from Access you can use the Refresh
command. It is extremely fast.
 
Okay, that's a good idea, i am wondering though, would it jepeadize any of
the data on the access part of the database? Could it get screwed up somehow
or is it usualy un-prone to that?
 
Back
Top