|
AppendAsPerFieldPos.mdb |
Post Reply 
|
| Author |
 Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search  Topic Options
|
A.D. Tejpal 
Microsoft MVP 
Joined: 01 Jul 2008 Online Status: Offline Posts: 154 |
 Post Options
 Quote Reply
 Topic: AppendAsPerFieldPos.mdbPosted: 10 Jul 2008 at 9: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.
|
|
 |
|
|
Post Reply
|
| 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 |
