Print Page | Close Window

AppendAsPerFieldPos.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=143
Printed Date: 10 Dec 2017 at 10:42pm


Topic: AppendAsPerFieldPos.mdb
Posted By: A.D. Tejpal
Subject: AppendAsPerFieldPos.mdb
Date 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.

Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/AppendAsPerFieldPos.zip - uploads/37/AppendAsPerFieldPos.zip



-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window