copying tables in Access to a cd

L

Linda

I need to copy 4 tables from an Access database to send to the state on a cd.
I can send the entire database but most of this information is protected by
law . "Help" in the case wasn't any help. Can someone tell me how to do
this?
 
D

Douglas J Steele

Tables in Access don't have an existence of their own: they can only exist
inside an MDB (or MDE) file.

One option is to create a new database, and import the 4 tables into the new
database (through File | Get External Data | Import).

Another is to export the data to, say, Excel, and send the spreadsheet.
 
K

KARL DEWEY

You best and easiest way is to build a query that gives you the data you wish
to convey. Run the query and then click in the upper most left corner to
highlight all the results, copy and then paste in a Word document. It will
paste as a table in Word.
 
L

Linda

Thank you, it worked!!

Douglas J Steele said:
Tables in Access don't have an existence of their own: they can only exist
inside an MDB (or MDE) file.

One option is to create a new database, and import the 4 tables into the new
database (through File | Get External Data | Import).

Another is to export the data to, say, Excel, and send the spreadsheet.
Click to expand...
 
L

Linda

Thank you very much.

Joseph Meehan said:
Having been with a State tax department, I suggest you start by finding
out what format(s) the state will accept.

Assuming they will accept Access, you could copy your current mdb and
then delete the tables and fields that have information you do not want to
pass on to the state. Then send them that database.

It could be they would prefer a text file likely comma delineated.
Click to expand...
 
Top