Is it possible to save tables to a floppy or CD?

[Guest]

I can't find a way to save tables to a floppy or CD. Can anyone help?

 

[Guest]

You cannot save tables as standalone files - they must reside inside an .MDB
file. You *can* write the MDB to removable media after exiting Access, but
only for moving to another machine - DO NOT EVER open it from removable
media.

 

[Jeff Boyce]

Charles

Access saves tables (and everything else) inside a single .MDB file. But if
you need the data that's in a table, you could:

* write a query to return that data, then Export it to another file format
(e.g., Excel) and save that file
* open a new (empty) Access database and Import that table

Now, whether or not it will fit on a floppy or on a CD is entirely up to
you -- how much data is in the table?

 

[Kyle]

Jeff,

Is there a problem in opening the table and going to File->Export and
exporting the table, saving the file to the floppy or CD?

That offers a variety of ways to save the table, including Excel, RTF,
and even XML, yes?

 

[Jeff Boyce]

Sure.

If you want to export less than the entire table, or want to export data
from your table plus related data from other tables, use the query approach
I mentioned.