Export table

tmferraro

New member
Local time
Today, 02:29
Joined
Aug 12, 2012
Messages
1
I need to export a table from a 2003 Access DB to a Access 2010 DB.
 
I think you can just open the old database files in Access 2010 and then save them as the new version.
 
Welcome Aboard:)
Access 2003 cannot talk to an .accdb so if you need to automate the export from that perspective, you need to export to a csv, txt, or xls file or an intermediate .mdb.
Then the A2010 application will need to import from the intermediate csv,txt,xls, or mdb file.
 
Left column, All Access Objects, export is what I tried. But it seems to want the file already existing in order to do a export.



Bob
 
I don't have MS-Access 2003, but both in MS-Access 2000 and MS-Access 2010, the following would do it.
Mark the table to export in the database - right click, choose export.
 
do it the other way

import the table into the A2010 dbs.

sorry. i see this is an old thread.
 

Users who are viewing this thread

Back
Top Bottom