Is there a way, either within Access 2002, or with a third party tool,
or even some code on the internet, to generate the SQL statements that
would recreate a table and its data? I know that in mySQL, when you
do a backup, it creates a large file full of SQL statements that are
run when you do a restore. I don't mean using the query tool for
looking up data, but I am looking for something that will generate the
CREATE TABLE and INSERT INTO statements for a given table and its
data.
Sincerely,
Marc DVer