copying tables in Access to a cd

[Guest]

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?

 

[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.

 

[Guest]

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.

 

[Joseph Meehan]

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?

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.

 

[Guest]

Thank you, it worked!!

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.

 

[Guest]

Thank you for the information. Will give it a try.

 

[Guest]

Thank you very much.

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.