Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import / export data | New Users to Excel | |||
How do you program Excel to import/export data to XML files | Excel Programming | |||
export/import excel data to word doc. properties | Excel Programming | |||
Import data, calculate, export data | Excel Programming | |||
Create workbook for data export and then data import? | Excel Programming |