Export data from Excel to MS SQL Server

Question

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

Answer 1

some button/macro/excel feature

There is no such build-in feature available, so you have to develop such a solution or hire a freelancer to implement it.

Answer 2

@Ravi Kumar ,

There are several ways to import data from Excel files to SQL Server or to Azure SQL Database. Some methods let you import data in a single step directly from Excel files; other methods require you to export your Excel data as text (CSV file) before you can import it.

For details, see https://learn.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql?view=sql-server-ver16
Hope this helps!

--please don't forget to upvote and accept as answer if the reply is helpful--

Answer 3

You mix up import/export and from/to in a confusing way, difficult to understand what you exactly want to do now.

Anyway, it's a ETL = "Extraction, Transforming, Loading" process and for this there are several dedicated tools. https://en.wikipedia.org/wiki/Extract,_transform,_load
The MS product is SSIS = https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16

Answer 4

Use VBA and ADODB connection using stored procedure to export data (more then 100 rows).

Regards.