Import Data / Edit Data / Export Data in Excel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top