Is it possible to copy an Access form or table to Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a novice Access user and I've created a database of our equipment. I
want to copy the data to Excel and to also copy the Database to our network.
I don't get an option to "save as" when I save the database.
 
hi,
access was designed as a multiuser database and it is not
wise to "save" the database while other users may be doing
work in the database. for that reason access doesn't have
a "save" function. you can save forms, queries, reports
ect but not the database in total.
you can tranfer a copy of the database using explorer.
 
frc said:
I am a novice Access user and I've created a database of our equipment. I
want to copy the data to Excel and to also copy the Database to our network.
I don't get an option to "save as" when I save the database.
Click to expand...


File > Export change the file type to Excel. You could also just run
a query and copy and paste the results to a spreadsheet.


gls858
 
I am a novice Access user and I've created a database of our equipment. I
want to copy the data to Excel and to also copy the Database to our network.
I don't get an option to "save as" when I save the database.
Click to expand...

An Access database (unlike an Excel workbook) IS NOT A DOCUMENT.

It's a container for multiple Tables, Forms, Reports, Modules, and
other objects. As such, you cannot copy "the database" to Excel.

What you *can* do is use File... Export... to copy the data *in a
Table or a Query* into an Excel spreadsheet, a new one or an existing
one.

It would be unwise to copy the entire .mdb file to the network; having
the same data stored in two different places (which can then be edited
independently) is a sure-fire recipe for trouble. You can have the
tables *shared* among users by moving (not copying!) the database to a
network folder; if you do so it's best to use Tools... Database
Utilities... Database Splitter to "split" the database into two parts,
one (the shared "backend") with just the tables, and the other (the
"frontend") with all the user interface stuff.


John W. Vinson[MVP]
 
Hi,
Thank you for your response. I was able to export the table I needed to
Excel.
Have a great week!
frc
 
Hi,
Where would I go after Database Utilities to "split" the database?
Thank you.
Click to expand...

ummm... wherever you like.

Once the database is split, you can open the "frontend" and use it in
almost exactly the same way that you would use an unsplit database.
The only thing you can't do (without a change to the code) is use the
SEEK method on a table-type recordset.

John W. Vinson[MVP]
 
frc said:
Hi,
Where would I go after Database Utilities to "split" the database?
Thank you.

snip<
Click to expand...

Tools > Database Utilities > Database splitter. Follow the prompts.
 
Back
Top