RE: [AccessDevelopers] Change Excel Column Name

Mon, 16 Jan 2006 05:45:43 -0800

Thanks Norman,
 
Actually this is my objective, but everytime I will import the excel file the last two colums heading is always different so I cannot fixed that to my append query.
 
I want to achieved this in one click of a button.
 
TIA,
George
 
-----Original Message-----
From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Pearce, Norman
Sent: Monday, January 16, 2006 5:17 PM
To: 'AccessDevelopers@yahoogroups.com'
Subject: RE: [AccessDevelopers] Change Excel Column Name

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



Reply via email to