SQLTeam.com | Weblogs | Forums

Create database in SQL from excel files


Hello guys!
I am still the newbie in this field so I really appreciate it if you could help me.
This would be my task. I used "Summary" tab as an example.
Every week I get a couple of excel files that have the same format. I need to "edit" that format in format that I need in SQL.
So, in the example you can find 2 sheets: "Summary" and "AAA" and these are the original tabs that I get from my colleagues. Because they are "merged" my first step is to unmerged them and you can see the results of that in sheet "Summary after unmerging".
After unmerging them, I need to put the data in new "order" and you can see that results in sheet "FINAL Summary table in SQL".
As I said, I have a couple of excel files that I need to "union all" (data) in SQL and create one table.
So, if this, how would I say, first step is doable the next step would be to update this "ONE TABLE" every week form those excel files that I get.

Thank you in advance.

P.S. how to upload excel file here?


Not sure that you can - or you might not have enough posts to be allowed to attach files?

Can you host the file somewhere else and just post a LINK to that location?


I'll put file later today.
Thanks for info.