LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Database or Access?? Centrol Excel Worksheet Functions 1 October 27th 08 09:56 AM
Do I need Excel or Access for my database needs? Emily Excel Discussion (Misc queries) 3 February 21st 08 05:04 PM
Update a Database From Excel Sh0t2bts Excel Worksheet Functions 0 August 7th 06 03:13 PM
Update a Database Using Excel Dmorri254 Excel Worksheet Functions 1 April 11th 05 07:56 PM
excel to get data from an access database confused Excel Discussion (Misc queries) 1 February 18th 05 06:29 PM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"