excel-->XML-->SQL

[Jano]

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

J

[Dino Chiesa [Microsoft]]

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...ractToExcel.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

"Jano" <Ja**@discussions.microsoft.com> wrote in message
news:17**********************************@microsof t.com...

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

J