[AccessD] Append Query

Might mention that you can refer to the fields by position instead of
name... not sure it will help, but just in case the data comes in the same
order, just with different names -- can't remember the syntax off hand, but
if this sounds useful, I'll look it up.

Susan H.


> If you aren't sure what the field names are going to be in the table
> you're importing, it's a bit difficult to automate.  Are you even sure
> the fields will be in the same order and without any additions or
> deletions?  I've found when handing stuff like this that it's best to
> just import the data into a new table and then move it into the import
> table after examining it.  That gives you a chance to make sure you know
> what you're getting first and allows you to customize the necessary
> append query as needed.  I wouldn't try to automate this on a bet
> because I know exactly how reliable that kind of data turns out to be.
> It's better to be safe than sorry.
>
> Charlotte Foust
>
> -----Original Message-----
> From: Terri Jarus [mailto:jarus at amerinet-gpo.com]
> Sent: Tuesday, June 10, 2003 7:25 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Append Query
>
>
> I have data that I have imported into my database into a table named
> ImportTbl.  I will be doing this quarterly - and each time this happens
> the field names get changed around a little bit by the person submitting
> the data.  For example, they might call the field Q1 Sales and then the
> next time Q2 Sales - which isn't too bad, but then there are other
> fields like Hospital Name, they might call Facility Name.
>
> I want to transfer the data from the ImportTbl to another table that I
> have established generic field names - such as Sales, Name, etc.  I then
> have set up queries, reports etc, based on this table (UpdateTbl).
>
> What is the best way to do this programmatically?
>
> Thanks for any help on this.
>
> ------------------------------------------------------------------------
> ---
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individuals or entities to whom they
> are addressed. If you have received this email in error please return
> it to the sender, and erase any copies thereof.
> Copyright 2003 Amerinet 1nc.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>