Export table

[tmferraro]

I need to export a table from a 2003 Access DB to a Access 2010 DB.

 

[Sasoriza28]

I think you can just open the old database files in Access 2010 and then save them as the new version.

 

[Pat Hartman]

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.

 

[amerifax]

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

 

[JHB]

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.

 

[gemma-the-husky]

do it the other way

import the table into the A2010 dbs.

sorry. i see this is an old thread.