ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Import Data / Edit Data / Export Data in Excel (https://www.excelbanter.com/excel-programming/393725-import-data-edit-data-export-data-excel.html)

Mathias Fritsch

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