1

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.

Improve this question

2 Answers 2

Reset to default
1

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.

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

Comments

0

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

Make sure they both have the same column name.

also you can acte like this

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.