AppendAsPerFieldPos.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 1:55am |
This sample db demonstrates append action from one table to another, using field positions (instead of field names). The technique can be handy for a set of tables having large number of fields, where data types across the tables are similar but field names are not. The main subroutine accepts five arguments (name of source table, name of target table, desired start column in source table, desired start column in target table and number of columns to be covered in the range). Last three arguments are optional. If omitted, all columns (except the one for auto- number field) get appended.
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |