Share via

Refreshing Tables

Stephen Daff 0 Reputation points
2024-04-09T04:59:19.5166667+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,834 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,736 Reputation points
    2024-04-09T05:38:35.45+00:00

    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.

    1 person found this answer helpful.
    0 comments
  2. hossein jalilian 7,280 Reputation points
    2024-04-09T06:04:16.43+00:00

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.