ChiTownDiva
Technical User
Afternoon All...
I was wondering if there was a way to append a number of tables based on, say the table extension (i.e. _txt would be an extension) to a "master" table with out writing individual queries to accomplish this.
An example:
Odom_txt
sacra_txt
phil_txt
Master EDI Feed
The tables with "_txt" extension are the tables I would want to append to the "Master EDI Feed" table. The number and names of the tables in the database would vary, otherwise I would simply write queries and then create a macro.
Is there a way to accomplish this programmably?
Thanks in advance for any assistance with this.
ChiTownDivaus
I was wondering if there was a way to append a number of tables based on, say the table extension (i.e. _txt would be an extension) to a "master" table with out writing individual queries to accomplish this.
An example:
Odom_txt
sacra_txt
phil_txt
Master EDI Feed
The tables with "_txt" extension are the tables I would want to append to the "Master EDI Feed" table. The number and names of the tables in the database would vary, otherwise I would simply write queries and then create a macro.
Is there a way to accomplish this programmably?
Thanks in advance for any assistance with this.
ChiTownDivaus