access to excel (2003)

[Liz]

i have an access database of about 600 tables...is there anyway i can export
all of the tables (and information) to excel on one worksheet. i need to
audit the information and remove old information.

 

[Jeanette Cunningham]

Liz,
600 tables? Are many of the tables copies of the same table, but with
different records?
If yes, you could create a union query using those tables.
If no, give us a bit more information to work with and we will be better
able to help.
I am guessing that you don't feel comfortable creating forms to edit the
data - if you know access, this would be easier that trying to do it in
excel.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Liz]

Thank you for responding Jeanette. Yes they are all the same table layout but
there is one for each employee (i work in HR). I'd like to weed out old
records in an efficient manner and just though having them in excel on one
list would be easier but i am willing to try anything if it will work better.
.. I am a novice at access so if you have detailed step by step instructions I
would greatly appreciate it . PS I dont know how to create a form. this is
a database that was not created by me.

 

[Jeanette Cunningham]

Liz,
if you are a real novice at access, it will be easier for you to work in
excel.
There is quite a steep learning curve to build an access database.
If you knew how to use access, you could do it in about 15 mins.
If you know someone who is good with access, they could do it for you.
(put the data in one list in excel).
Otherwise, I am sure it would be quicker for you to just export each table
to excel one at a time.
Does this database have any forms for editing the data or any forms that do
anything else?
It sounds as though the 'database' you have is just the very start of a
database.
A finished database would have forms - screens to make it very quick and
easy to weed out the old records and add new ones and get reports.


Jeanette Cunningham -- Melbourne Victoria Australia

 

[Liz]

No Jeanette there are no forms, reports or queries at all. Only tables. I
will just use the excel report to review the access information but then go
back and manually delete the old records. I'd love to take a training course
in access to better understand it.