keep column name when exporting to excel

[devquest]

I am using the import / export wizard to export data from a sql table to an excel spreadsheet. The column name is Image Url #1 , but when I export it, it becomes
Image Url .1 instead. How can I prevent this?
thank you.

[ck9663]

1. Create a view with the column name as the first record UNION ALL with the entire table.
2. Export your view without a header.

Happy Coding!!!

~~ CK