CODEWITHSUNDEEP
sql-serverdatabaseexceldatabase-connectionconnection-string
user3758689
user3758689

Reputation: 41

How to connect Excel to SQL Server 2014

I have data in an Excel spreadsheet with 9 columns. How do I fetch this data into an existing table in SQL Server?

By using the Import & Export tool, I need to create a new table which I don't want.

Upvotes: 1

Views: 634

Answers (2)

Dudi Konfino
Dudi Konfino

Reputation: 1136

Use SSIS. Source=Excel, destination = your table.

Make sure they both have the same column name.

also you can acte like this

Upvotes: 0

Kash
Kash

Reputation: 264

With Import Export tool also you can import data to the existing table. At the time of Importing data option is available whether you want to delete all existing table and import fresh data or append data.

Upvotes: 1

Related Questions