Excel - How to get column names?

[Jendy]

Hello,

I need to get column names from Excel and compare it. Is it some way, how to do that?

And after compare I will need change their names or something. Is it some way, how to do it?

Thank you for ideas,

Jan

[Jvang]

@Jendy,

Can you explain more in detail what you're trying to compare it to? Like to a sharepoint list? SQL table? ect.

You can just copy and past from excel straight to the source you need it to be in, or if there's an option, you can upload your excel file on to it.

Thanks,

Jvang

[Jendy]

@Jvang My goal is create table header with names (employees). I have table in SQL and I want to compare excel and SQL.

In case that employee exist in Excel but no in SQL, I want to edit value with name in Excel - Missing_Name or something like that.

[Jvang]

@Jendy,

The only think that comes to mind is creating a 2nd table in SQL with names as a header (Identical to your Excel sheet of employees)  and then have a PK(primary Key)  that wont have null values and create a trigger that would update the main table base on the PK when insert/update/delete data from the other table.

Thanks,

Jvang