need query with duplicate aliases into excel

[phineas629]

Hi all,

I am editing a query that exports into Excel. The problem is I now need duplicate named columns in the excel file. I am getting error ''duplicate output alias''. Any suggestions for a workaround? I just need the duplicates in the excel file. Duplicate columns does not exist in the database.

Thanks

[June7]

Open the Excel file as an object in VBA and manipulate the object.

Why is this needed?

[phineas629]

In excel, the duplicate columns identifies properties of other columns. It is a requirement.

[June7]

But why do they have to have same header?

If they must be same then I still think will have to open the Excel as an object in VBA and manipulate to set those cells with whatever text you want.

[phineas629]

Thanks, the requirements were changed but I'll keep your recommendations in mind if I should run into a similar situation.