Need Table/Query Script Generator
Posted on 2003-02-24
Is there an Access equivalent to the SQL Server "Generate SQL Script" task?
I need to create a text file (or text output to window) that contains the code to recreate an Access table. The user should be able to select the table (or all tables) from the Access DB.
Of course, then I need a way to "execute" this script to recreate the table(s) from the text file.
So, the successful answer to this question will provide (1) instructions for using the Access built-in wizard/task, or (2) third-party code, or (3) your custom code to:
1. Select one or more tables/queries from an Access DB and write the script to a text file/window that defines the table(s)/queries and can be used to create the table(s) in another DB.
2. Run the script from #1 and create the table(s)/Queries in another DB.
Please keep this as simple as possible. A useful option would be to just output the table/query definition in a nice, readable format suitable for posting in a web forum. I would like to be able to give this to a remote user (who may be a novice programmer) to use and send the script to me so that I can provide better tech support/debugging.