MS SQL XML - SQL auto export/import to Excel (via XML?)

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL auto export/import to Excel (via XML?)

Content

2005-09-08, 7:24 am

I need to create some easy to use system where employees can
download/import and fill out checklists in Excel (filling out must be
off-line), which data must be imported/updated in SQL Server
afterwards.

Any recommendations? I was thinking about several options, f.e.:
-create a XML export function in SQL Server, let user download the XML
and manually import it in Excel, fill out and export again
-automatically create a blank Excel file via ASP.NET (if possible?),
let the user download it, fill it out and upload again, import in SQL
Server
-...?

For practical reasons I'm bounded to Excel in this case (linking to
other Excel sheets), I'm afraid f.e. creating a client VB.NET app will
not suite in this case.

Thx for any comments.

Sponsored Links