[pnj]

we have a very small, 3 table access DB that gets updated every so often w/ our schedule. we also have an excell document that has the same data that gets updated by hand as well.

is there a way to only enter this data once in the DB and then have it dumped into the excell doc. in the correct format?

it seems like there is a better way then entering the data twice....

 

[gecko]

Originally posted by pnj
we have a very small, 3 table access DB that gets updated every so often w/ our schedule. we also have an excell document that has the same data that gets updated by hand as well.

is there a way to only enter this data once in the DB and then have it dumped into the excell doc. in the correct format?

it seems like there is a better way then entering the data twice....

There's always a way. Might require hiring a pro to get it setup for you though. You'll likely need some sort of conversion script written.

 

[pnj]

Originally posted by gecko
There's always a way. Might require hiring a pro to get it setup for you though. You'll likely need some sort of conversion script written.

not worth hiring a pro. it's a very small DB. I just thought if someone knew a simple way I could make the lady happy that fills out both DB and the spreadsheet.

 

[johnbryanpeters]

From the menu:
Data | Import External Data | New Database Query

would be the starting point (This based on Office XP Professional SP1).

J

 

[pnj]

Originally posted by johnbryanpeters
From the menu:
Data | Import External Data | New Database Query

would be the starting point (This based on Office XP Professional SP1).

J

sweet!

although, I couldn't get it to fully work as the tables aren't joined.....

something I might do down the road sometime. when I have time....

thanks

 

[johnbryanpeters]

Create a query in the db that does the join you want, then point Excel at the query.

J

 

[Toddly]

If you have a query or a table within the database there is a Section under Tools>Office Links > Analyse with Excel. I have used that before. It might help.