Hi all,

I support a number of applications that store info in backend SQL databases. A project has come up where I need to get data out of Excel into one of these databases, using XML/XSLT. I am a beginner in XML/XSLT so was hoping someone would be able to give me some good info/tips on how to do this, and/or pointers to examples/documentation.

I would like to do draw up something using VB.NET as I have Visual Studio as well as some skills in this area. Also, i've got a week and a half deadline on this!

Thanks all

Is it a business requirement to get the data out of Excel using XML?

Can you not use the OLEDB driver for Excel, and ADO.NET ?

you could do something like the following, only in reverse.
http://www.winisp.net/cheeso/srcview.aspx?dir=MSOffice&file=ExtractToExcel.cs

-D

--
Dino Chiesa
Microsoft Developer Division
d i n o c h @ OmitThis . m i c r o s o f t . c o m



[quoted text, click to view]
databases. A project has come up where I need to get data out of Excel into
one of these databases, using XML/XSLT. I am a beginner in XML/XSLT so was
hoping someone would be able to give me some good info/tips on how to do
this, and/or pointers to examples/documentation.
[quoted text, click to view]
as well as some skills in this area. Also, i've got a week and a half
deadline on this!
[quoted text, click to view]