Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Exporting data from Microsoft Access 2007- 2010

Posted on 2012-08-22
Medium Priority
Last Modified: 2012-08-27
I want to give some data to another Microsoft Access 2007 user.  I right click on the table I want to export and see the export choice.  If I choose Microsoft Access as the file format, it asks me for the name of the destination file.  Then when I hit ok I get an error saying the file doesn't exist.  

OK, so how do I do this?

And what If I want to export several files into a single Access file, I notice if I select multiple tables, when I right click, the export choices are all greyed out except word merge.


Question by:cipriano555
LVL 13

Accepted Solution

Ryan earned 1000 total points
ID: 38321368
I think you're mixing up the words files and tables.  
I usually IMPORT tables from the empty database, rather than exporting to it.

If its simply 1 database, it's probably easier to make a copy, and then delete out what you don't want.  Then do a compact and repair on it.

If its just 1 or 2 tables, it may be easier to export as CSV files.
LVL 49

Assisted Solution

by:Dale Fye
Dale Fye earned 1000 total points
ID: 38321413
Or create a new database, and use then import only the tables you need.

If you want to do this via code, use can use the dbengine.CreateDatabase method to create the new database, and then use the docmd.TransferDatabase or docmd.CopyObject methods to copy the tables to the destination database.

Author Comment

ID: 38336668
Thanks for your great advice, and yes I did accidently say File when I meant Table above.  What I have learned is that you must export to an Access database, it won't create the target database for you as part of the export process (which I find surprising).  So actually, I can right click in a folder, and choose New/Microsoft Access Database, and it will create an empty database for me.  Then when I go to export, I choose this database and everything works fine.  And right, going to the new database thusly created and doing an Import might be easier.



Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question