RE: [AccessDevelopers] Change Excel Column Name

[Pearce, Norman]

George   How about just a straight and quick import into a table named something like ImportedExcel And then follow that up with an Append Query into the destination table.   Sorry for the quick and short response, got a course starting in 10 minutes.   Regards   Norman Pearce IM&T Learning Manager The Training Centre Ealing Hospital NHS Trust UK Developing the foundations for your success       -----Original Message----- From: George Oro [mailto:[EMAIL PROTECTED] Sent: 16 January 2006 12:19 To: YG Access Dev; YG Access Subject: [AccessDevelopers] Change Excel Column Name   I want to import one excel file but before my code will execute, I want to change first the last two columns heading into PrevReading & NewReading.   The reason is, the excel file is extracted from a different software using a pre-defined template but the last two columns heading is the Previous Reading & New Reading Date with their respective data. Basically each export from the other software, the last two columns heading will change according to date reading so its not fixed at all.   The exported excel file is always composed of 10 columns and save in the same directory and file name.   Any tips would be greatly appreciated.   TIA George       Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.