Script to Update a Excel Database whenever a Access Database is mo

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.
 
B

Beetle

What do you mean when you say you can't print the information
in your Acess db? Why not?
 
F

Finnbar

The way it was designed ~7 years ago does not allow printing i believe,
because you type in a customer name and it brings you to a customer page with
all the information, but it's individual, it doesnt give you an "overview" of
all the customer information like you would see in excel.
 
B

Beetle

In Access, you use Reports for printing information. What you would
typically do is create a query of the information you want to see, then
create a report based on that query. If you are unfamiliar with doing
either of the above you can use the built in wizards.

Since your original question was about creating a script, I'm assuming
that you have access to the design side of the application so that you
can do the above. I think you would find this a much easier solution than
trying to keep two different applications in synch just so you can print
information occasionally.
 
J

John W. Vinson

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.

As Beetle says... why on Earth do you feel that you can't print data from
Access? The program has a very powerful report generator; anything that you
can print from Excel can be printed from Access.

If you have some need to manage the data in Excel, be aware that you can use
Excel as a frontend to Access. It's neither necessary nor good practice to
store the same data in two different places.
 
F

Finnbar

Would linking the Access database to an Excel file which updates whenever i
open it up jeaperdize any of the data on the access database?

The thing i want to accomplish really, is to be able to see all the
information without having to go trough each individual customer info,
rather, just see all the information in a big page with all the info on it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top