Click here to Skip to main content
14,603,499 members
Rate this:
Please Sign up or sign in to vote.
I would like to build a project on the below idea.

data engineer is making data on their template. I have a database containing all the columns but not in the same order as the data engineer has.So after uploading the excel file the coloum matching should done and then the date is stored in the db template.

What I have tried:

Starting phase.posting this question for getting an idea. plz help
Updated 16-May-18 21:53pm

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Yes it is possible.

You can write some C# code to do it or use SSIS.

You will be in full control of what goes where on the target table.

Import data from Excel to SQL | Microsoft Docs[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100