Exporting data from Microsoft Access 2007- 2010

Posted on 2012-08-22
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

    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 47

    Assisted Solution

    by:Dale Fye (Access MVP)
    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

    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

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now