Replicate a MSSQL Table in VB Code

[MattN]

Currently I have an import table which inserts data into temporary tables which I have manually created.

Whenever I add a field to the import table I need to manually add the field to the other tables. This is obviously time consuming and primitive!

I would therefore like to be able to create an exact copy of a import table within VB Code. By doing this I can then only update the Import table. All the temporary tables will then automatically be created.

Thanks

Matt N

 

[x508]

I'm sure I read somewhere in the MySQL online pages that MySQL now supports a query with which you can copu one table (Duplicate on table) with a simple SQL query.

I MySQL AB can do this, I'm almost certain that Microsoft will be able to udo the same...

Just a thought

Hope this helps

*****************************************
May the Code Be With You...
----------
x50-8 (X Fifty Eigt)