Terri Jarus
jarus at amerinet-gpo.com
Tue Jun 10 12:14:09 CDT 2003
It seems that it usually comes in the same order and the same number of fields. I did this once before and recently someone overwrote the database. I'm having trouble with the network guys recreating the backup - so now 2 weeks in, I decided to try to recreate the database myself. Only problem, I can't remember how I did this. I either found a way to rename the fields to be more generic (via code) OR somehow used an append query and selected the fields on a LIKE type of basis - if LIKE "*Sales*" then .... I need to do this programmatically as the enduser doesn't have a clue how to deal with any of this. But I don't recall - I'm trying to work backwards as the data was then pulled into Excel through MS Query - the spreadsheet is still intact with the code used there, but I don't know how I initially got the data setup for the spreadsheet. Pretty sure I didn't use the position idea as that doesn't sound familiar at all. Anyway, thanks for the suggestions. I'll just keep plugging away. >>> cfoust at infostatsystems.com 06/10/03 11:41AM >>> 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