How to export MS Access database into 'insert' file

[nguyencp]

Hi,

I have a bunch of Microsoft Access database, I want to export them into
'Insert' statement file so that I can readily make the databases again
somewhere else.

I found a lot of sites/tips to export MS SQL database to 'insert'
statement, but I haven't find anything on exporting MS Access database.



If anyone know how to export MS Access database into 'insert' statement
file, please let me know.

 

[Douglas J. Steele]

Do you really mean "Insert statements", or do you mean "Create statements",
so that you can create the same tables in another database?

Either way, there's nothing built into Access to accomplish this.

If you have the "old" database around, you can always use the
TransferDatabase method to copy the tables from the old database to the new
one. There are two modes when copying tables: one copies everything, one
just copies the structure of the table, with no data.