PDA

View Full Version : access data into excell?

pnj
10-15-2003, 11:56 AM
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
10-16-2003, 05:27 PM
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
10-16-2003, 05:43 PM
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
10-16-2003, 07:39 PM
From the menu:
Data | Import External Data | New Database Query

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

J
pnj
10-17-2003, 10:18 AM
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.....:rolleyes:

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

thanks
johnbryanpeters
10-21-2003, 12:57 PM
Create a query in the db that does the join you want, then point Excel at the query.

J
Toddly
10-27-2003, 09:50 PM
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.