delete duplicate column in the excel from MS ACCESS

[yan19454]

I have excel file which has two columns with the same name. I can't import the file into MS Access. Will you please give me the code to delete one of duplicated column first in MS VBA code so that I can import.

Thx.

 

[SkipVought]

Is this an on-going problem? Why not just open the Excel workbook and change the duplicate heading?

Short of that, check out the GetObject Method. Quite an extinsive example in help.

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]

 

[yan19454]

it need to be update daily. I do not think I like to open the file and delete that daily.

 

[SkipVought]

"...check out the GetObject Method. Quite an extinsive example in help."

Skip,
[sub]
Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty![/sub]