Refreshing Tables

Question

Hi... I am hoping someone can assist.

I have created a table straight from an Excel File. What I later on change the contents on the Excel file, the change is not reflected when I go back to SQL Server Management Studio when extracting a new query.

I hope that make sense..... Cheers

Answer 1

I hope that make sense..... Cheers

No, not really.

If you use the Import/Export Wizard to import data from an Excel file, then it's a one-time-job.

You have to import the Excel file again to get new data.

Answer 2

Thanks for posting your question in the Microsoft Q&A forum.

I hope this article can help you:

How to Update an SQL Table from Excel

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful