Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Is there a script to automate changing headers in an excel file? say..excel 2003?

I want to change the headers to be Active Directory Import friendly.  So for example I have email address I want to change to a heading called "mail" and lastnames to the ad friendly surname.  How can I do this?  Thanks.
0
Sp0cky
Asked:
Sp0cky
1 Solution
 
pteranodon72Commented:
It sounds like you are exporting a table to Excel and have undesirable field names.  Why don't you just create a query on the table, drag all the needed fields onto the grid, and rename the fields in question by typing a NewName: in front of the current field name.  Then, just export the query instead of the table.

The query SQL will look something like

SELECT  email as mail, lastname as surname, ..... FROM yourTable;

HTH,

pT
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now