Update Excel Database via Access Main Database with a script

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

 

I think you might do better on say the microsoft technet forum... not a notebook forum...

 

Well i did, but since this is a windows os/ software, then im sure some knowledgeable people can help

 

I know this is the Windows section and we're all glad to help - it's why we're here. Just was suggesting you might see better help there, as this is a pretty specific question. I know I don't know the answer (though that does not mean no one will of course!)

 

Lol, i know what you meant, that's where i posted my question initially, but i got some generic response saying "why cant you just print it"

But thanks again Hep!

 

You can use Office Data Connection to retrieve information stored on your Access database.

 

Mhmm, that seems to be getting closer to what i am looking for, but where can i find this Office Data Connection?

Because my biggest thing is that it does it automatically, like i dont know a script written in perl, python or whatever that automatically copies the new data on the access database to the excel database...

 

As a database programer, I must say I think your approach is all wrong. Trying to keep these two versions of the same data in sync is going to be a headache forever. Even if you do get the Access to Excel automation to work, what would prevent someone from editing the excel data? It would not flow back to the Access database.

I see two better solutions for you. The first is to create a report in the access database that you can print. Format the report so it looks like the results you are getting from the Excel file. Or link the Excel file to the Access database. This leaves the ONLY source of the data in Access and when you open the Excel file it pulls its data from the Access file.

Gary