[AccessD] Append Query

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