topic Export data from Excel to MS SQL Server in Developer

Export data from Excel to MS SQL Server

Ravi_R2K — Thu, 10 Nov 2022 05:21:07 GMT

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

Re: Export data from Excel to MS SQL Server

Habitat — Thu, 10 Nov 2022 13:12:20 GMT

Maybe you should post this in other forums about Excel

Re: Export data from Excel to MS SQL Server

Anonymous — Fri, 11 Nov 2022 06:35:40 GMT

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