duplicate column name export

[Pat_RI]

I have a table with columns called Part1,Part2,Par t3,Part4 and I would like
to export them to Excel but have each column called Part. Is this possible
without doing it manually? I would like the columns either in the table
renamed to Part or the columns in the exported table called Part. Any help
is appreciated.

Thanks,
Pat

[Salad]

Re: duplicate column name export

Pat_RI wrote:

I have a table with columns called Part1,Part2,Par t3,Part4 and I would like
to export them to Excel but have each column called Part. Is this possible
without doing it manually? I would like the columns either in the table
renamed to Part or the columns in the exported table called Part. Any help
is appreciated.
>
Thanks,
Pat
>
>

Look at union queries.