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
@Anonymous,
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
@Anonymous 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.
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tomac 497 Moderator
Michael E. Gernaey 477 Super User 2025 Season 2
chiaraalina 242
