- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

best way to push data from excel to sql server ..no of rows keep chaning in sheet ? any ideas
Hi Team,
Just wanted to know if any one can suggest best way to push data from excel to sql server ..no of rows keep chaning in sheet ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @shashank,
With one of 2 services (SSIS or Azure Data Factory), you could specify the share folder in server and ETL tools will import excel files in that folders. Just ask your end-users put data into that folder. This could be a traditional way for consolidation solution.
SSIS Refer topic and Tutorial: Create a pipeline with Copy Activity using Data Factory Copy Wizard
There is one notice that if you dont need to store data in sql server, you could skip this importing step and use query editor of Power BI to handle ETL process and gateway refreshing schedule to push directly data from excel to your reports.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @shashank,
Adding to other post, you can also use other methods to move data from Excel to SQL Server.
a. Configure Excel workbook as a linked server in SQL Server and then import data from Excel into SQL Server table.
b. Import data from Excel by using the OPENDATASOURCE or the OPENROWSET function.
c. Use VBA (Visual Basic for Applications) in Excel macro to export data from Excel to SQL Server.
For more details, please review the following articles.
How to import data from Excel to SQL Server
How-To Synchronize Data Between Excel and SQL Server
Export data from Excel to SQL Server
Additionally, the issue is more related to migration between Excel and SQL Server, please post the question in SQL Server forums or Excel forum. It is appropriate and more experts will assist you.
Thanks,
Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @shashank,
Adding to other post, you can also use other methods to move data from Excel to SQL Server.
a. Configure Excel workbook as a linked server in SQL Server and then import data from Excel into SQL Server table.
b. Import data from Excel by using the OPENDATASOURCE or the OPENROWSET function.
c. Use VBA (Visual Basic for Applications) in Excel macro to export data from Excel to SQL Server.
For more details, please review the following articles.
How to import data from Excel to SQL Server
How-To Synchronize Data Between Excel and SQL Server
Export data from Excel to SQL Server
Additionally, the issue is more related to migration between Excel and SQL Server, please post the question in SQL Server forums or Excel forum. It is appropriate and more experts will assist you.
Thanks,
Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You can use an Excel AddIn such as SQL Spreads (www.sqlspreads.com) to let your end users push the data directly from Excel to SQL Server. It can also handle different number of rows. (disclaimer: I work with SQL Spreads).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @shashank,
For on-premise solution:
- One time: could right click database instance and choose Task-> Import Data
- Automatic: build SSIS package and schedule job in SQL server to run ETL process
For cloud solution:
- One time: connect azure sql server instance in local SSMS and use import feature as above
- Automatic: build ETL process with Azure Data Factory (this serivce is same as SSIS but for cloud)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Seems very good ideas , but if i'm planning to build a model in excel which is supposed to be use by user who can push data any time as per there requirement then what would be the solution.
Many thanks for your inputs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @shashank,
With one of 2 services (SSIS or Azure Data Factory), you could specify the share folder in server and ETL tools will import excel files in that folders. Just ask your end-users put data into that folder. This could be a traditional way for consolidation solution.
SSIS Refer topic and Tutorial: Create a pipeline with Copy Activity using Data Factory Copy Wizard
There is one notice that if you dont need to store data in sql server, you could skip this importing step and use query editor of Power BI to handle ETL process and gateway refreshing schedule to push directly data from excel to your reports.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-26-2022 11:53 PM | |||
11-09-2022 09:21 PM | |||
03-14-2024 06:36 PM | |||
09-22-2023 12:40 AM | |||
07-03-2018 11:16 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |