Click here to Skip to main content
15,883,883 members
Search within:


Is it possible if we change any data in excel sheet then automatically update sql server table?
Please Sign up or sign in to vote.
0.00/5 (No votes)
Is it possible if we change any data in excel sheet then automatically update sql server table?
Posted
Add a Solution
Comments
Thanks7872 20-May-14 3:26am    
No.

1 solution

I believe the data sets retrieved from SQL Server are disconnection and therefore you need to write the changes back to the database. I would consider it extremely dangerous allowing the user direct access to the data with no intervening validation or controls.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
update Excel sheet data into SQL Server 2008
How to update or save the excel sheet data into Sql table
Error exporting data that from 5 table with inner join to excel sheet
Good morning. How can I automatically update a table through a view in SQL server
Excel sheet prompting for SQl Login .
can we create link table for an excel sheet in sql 2008 like ms-access?
Import Excell sheet in SQL Server 2005
export sql table data with column header to existing excel sheet
How to import from excel to multi relational SQL server tables using LINQ C#?
sql table import to excel sheet

Advertise
Privacy
Cookies
Terms of Use
Last Updated 20 May 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web04 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900