![]() |
Import Data / Edit Data / Export Data in Excel
I have a Database with a single table a user wants to edit in Excel
2003,2007. My plan is to 1 - export Data as XML from database to a fileshare 2 - the user clicks a button "Work on my Data from database" 3 - XML-Data gets loaded into a new Workbook. Certain columns are editable, others are not 4 - the user clicks "Save my Data to Database" 5 - edited XML-Data is saved to fileshare 6 - some process imports the Data to DB I have no idea how to handle 2,3,4,5 What would be a good way to handle the data in excel, especially to set enforce a dts - schema on the edited data? I prefer to do any programming in c#. regards Mathias |
All times are GMT +1. The time now is 06:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com