View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mathias Fritsch Mathias Fritsch is offline
external usenet poster
 
Posts: 1
Default 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