Can I convert an Access d/b into Excel?

M

Max

I am the only person in our 3-person office who knows anything at all about
Access (even though IMHO I know very very little). I have accepted a new job
elsewhere, and I want to leave knowing that the database will be able to be
used by the director and her assistant director, both of whom know only Excel.

Is it possible to convert the d/b? And is it easy to do? (I know nothing
from programming code and do not want to even attempt using it.)

Thanks in advance.

By the way, it has been quite pleasant 'using' this site for the past two
years to help me learn the bit that I do know about access. Thanks for
everyone's help.
 
P

Pat Hartman\(MVP\)

Access and Excel are not interchangeable. They can share data if that is
what you are talking about. You can export any tables/queries in your
Access database to Excel but if you want reports and calculations and forms,
you'll need to recode them in Excel.
 
M

Max

Well I don't exactly want them to be interchangeable, I want to permanently
change the information in one Access table (or query, or report) into Excel.

When you say "you'll need to recode them in Excel", I don't know what that
means. Do you mean that the information has to be entered manually from the
Access file into a new Excel file? Could it be done at all automatically --
even if it's just via the copy/paste method?

I know a little bit about Access, my bosses know absolutely nothing about
it. They are more knowledgeable about Excel, but now when it comes to Excel
working with Access. And I know absolutely nothing about Excel (other than
that it is better used for financial apps and utilizes something called
worksheets).

I am only part-time, so I have only about three days in which to do anything
-- any suggestions? After I leave, if I leave the information in Access, no
one will be able to do anything with it.

Thanks again.
---
In peace,
Max

Pat Hartman(MVP) said:
Access and Excel are not interchangeable. They can share data if that is
what you are talking about. You can export any tables/queries in your
Access database to Excel but if you want reports and calculations and forms,
you'll need to recode them in Excel.
Click to expand...
 
J

John Vinson

I am the only person in our 3-person office who knows anything at all about
Access (even though IMHO I know very very little). I have accepted a new job
elsewhere, and I want to leave knowing that the database will be able to be
used by the director and her assistant director, both of whom know only Excel.

Is it possible to convert the d/b? And is it easy to do? (I know nothing
from programming code and do not want to even attempt using it.)

Thanks in advance.

By the way, it has been quite pleasant 'using' this site for the past two
years to help me learn the bit that I do know about access. Thanks for
everyone's help.
Click to expand...

You can use File... Export on the Menu to export the *data* in tables
into Worksheets in Excel. Choose Excel from the "files of type" menu.

Queries can be exported, but they will no longer be "live" queries;
they'll be just static snapshots of the data using whatever criteria
you applied. In Access, if you change the data in a table; any query
based on that table will reflect the change. This will NOT be true
after the export; the query will be just like a static table.

If you have any Forms or Reports set up in Access they are a dead
loss: they cannot be exported to Excel.


John W. Vinson[MVP]
 
P

Phillip Windell

The only real solution is for whoever replaces you to learn how to deal with
Access like you did. There is no shortcut or easy way out.
 
M

Max

A co-worker passing my desk just suggested I open Excel to a new workseet,
and copy (Ctrl-C) the Access table, then paste it onto the Excel worksheet.
Is that a good way to get the data into Excel? It certainly seems easier
than importing or exporting. What would be the (if any) drawback to this
copy/paste method?
 
J

John Vinson

A co-worker passing my desk just suggested I open Excel to a new workseet,
and copy (Ctrl-C) the Access table, then paste it onto the Excel worksheet.
Is that a good way to get the data into Excel? It certainly seems easier
than importing or exporting. What would be the (if any) drawback to this
copy/paste method?
Click to expand...

<shrug> Excel users love copy/paste. I hate it. I don't see that it
would be all that much easier, but if it works for you, it will
accomplish the same end.

John W. Vinson[MVP]
 
Top