Read Excel-Xml as Embedded Ressource with OleDbDataAdapter

[Pieter]

Hi,

I have an Excel file, saved as XML-file, which is put as an embedded
ressource in my project. How can I read this Excel file using an
OleDbDataAdapter?

I know how to read an XML file as embedded ressource, and how to read a
normal Excel file with an OleDbDataAdapter, but what I need is the
combination of the two of them!


Anybody has any idea?

Thanks a lot in advance,


pieter

 

[Cor Ligthert[MVP]]

Pieter,

I don't know but when it was my problem I would try a memorystream and then
simple the dataset.ReadXML

http://msdn.microsoft.com/en-us/library/ms135419(VS.85).aspx

I don't know for sure how to say this in English in the same meaning as it
has in Dutch.

De dataset.ReadXML vreet bijna alles.
littary
The dataset.ReadXml gorges almost everything.

Cor

 

[Pieter]

Thanks Cor, I'll give it a try!

How are you doing?