How can i import Excel Data Into My Sql Server Table Only Using Stored Procedure

Question

I am new to using stored procedures I have an excel file that has few columns and data. I want to be able to read and insert the rows in respective columns in the table, but only using Stored procedures. I am using sql server 2017

A simple internet search will find many, many discussions of importing information from excel files. — SMor
– SMor, Commented Apr 2, 2019 at 13:51
Import data from Excel to SQL Server or Azure SQL Database. That said, I'm voting to close this question as too broad. — Eric Brandt
– Eric Brandt, Commented Apr 2, 2019 at 13:52
@SMor i posted this question after intensively searching..... also i wanted to know how to resolve my query using only stored procedures... i found many that used mvc, c# interface to achieve the task but i found none that did the same with only stored procedures — Nissim Anand
– Nissim Anand, Commented Apr 4, 2019 at 5:47

Randolph · Accepted Answer · 2019-04-02 12:42:33Z

1

A way you can easily do this is to save the excel file in CSV format then using Bulk Insert in the Stored Procedure. Bulk Insert, I think, doesn't accept parameters as the file location so you might also need to write the bulk insert script as a dynamic-SQL.

answered Apr 2, 2019 at 12:42

Randolph

3023 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can i import Excel Data Into My Sql Server Table Only Using Stored Procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related