7

I have an sql database and I am able to connect with excel spreadsheet. But when I update the table from excel directly it's not updating the database and once I click refresh all the entered data is no longer in the excel table

Is it possible to update sql database from excel without using any queries?

Improve this question
12
  • You can use SSIS, or using External tables. Commented Mar 11, 2017 at 8:28
  • "when I update the table from excel directly". How are you doing this? Commented Mar 11, 2017 at 8:30
  • @Nick.McDermaid , from the spreadsheet like any normal excel file Commented Mar 11, 2017 at 9:04
  • How does a piece of data get from the excel file into the database? Do you press a button? It's not normal for data on an excel file to end up in a database. You need to write some code of use some process to do that. Commented Mar 11, 2017 at 9:07
  • @Nick.McDermaid . Clicking the save button Commented Mar 11, 2017 at 9:15

1 Answer 1

Reset to default
6

Yes, you can directly via VBA or with other tools.

  1. via VBA (via qry)
  2. via SSIS (https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server-10-steps-to-follow/)
  3. via managament studio (https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/)
  4. via MS ACCESS (with ODBC connection to server) ...
Improve this answer
Sign up to request clarification or add additional context in comments.

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.