Importing Excel data to SQL and Establishing connection.

Hi, I am try to import data from Excel sheet to SQL, and Establish some sort of connection therefore, any changes made to Excel should automatically make change in SQL and any changes made in SQL should automatically change in Excel........just want to know if it is possible or not..and if so could you advise me thanks.
Just_flowAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
I don't suggest to have a both way updates architecture (which means the Excel file is sending over the data to MS SQL but at the same time, receiving data from MS SQL) as this may attract the risk of conflict of data.

What I would do probably is to have a clearer way of data flow, perhaps consider the MS SQL as the data source, yes, we could still using Excel to send data to MS SQL (this involves some programming either at MS SQL like a server side services/ETL program/etc or your local side like excel connection/program/macro/etc to establish the required process automation).

Similarly, when we try to "export" data from MS SQL to excel, depends on the existing environment or requirements, we would then decide which approaches could be used accordingly to automate the process.

hope this make sense.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Just_flowAuthor Commented:
Thanks for you suggestion @Ryan Chong, Indeed I decided MS SQL as the main data source and added connection to Excel and few SQL query to retrieve information :)
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.