M
Mathias Fritsch
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
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