Export data from Excel to MS SQL Server

[Ravi_R2K]

Hi, 

We have an excel that stores data in it. Some forms are created inside it that are not tabular in structure. So we can consider excel sheets act as individual pages as in any website. now we need to pull data from excel into database. 

1. I know that we can Import data into Excel from any database

2. I know that we can Import and Export data from any database to Excel/csv.

I am not looking for answers to above 2 questions.

I would like to know if it is possible to push data from excel to any database like, MS SQL Server, PLSQL Developer, Oracle, DB2 or any other database for that matter.

Data Flow: Trigger data flow from Excel to Database

Excel ---> Export data --> Database

Regards

Ravi Kumar

[v-shex-msft · Accepted solution]

HI @Ravi_R2K,,

I also think these should be more related to excel development instead of power bi, you can post these to excel related columns to get better support.

In addition, did these data table stored in multiple sheets or mixed in one sheet? If you mean the second one, the default database import feature should not be suitable to handle these scenarios. They will merge and combine these subsheets to one with blank row and columns.

Regards,

Xiaoxin Sheng

[Habitat]

Maybe you should post this in other forums about Excel