Exporting Table

[TK]

Finally figures out how to export a table to a text file, but can's quite
figure how to export a table from another database. Need to be able to have
a button that when the user pushes will go to the second database (where the
data is stored) and export it out as a text file in the local database.

Thanks

 

[John Vinson]

Finally figures out how to export a table to a text file, but can's quite
figure how to export a table from another database. Need to be able to have
a button that when the user pushes will go to the second database (where the
data is stored) and export it out as a text file in the local database.

Thanks

You can't export "a text file in the local database" - Access .mdb
file Databases can contain Tables, Reports, Forms and other objects,
but they cannot contain text files!

The simplest way to do this would be to use File... Get External
Data... Link to link to the other database and export the linked
table.


John W. Vinson[MVP]