Read Excel-Xml as Embedded Ressource with OleDbDataAdapter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pieter - 09 May 2008 12:08 GMT

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

Reply to this Message

Cor Ligthert[MVP] - 09 May 2008 14:37 GMT

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

> Hi,
>
[quoted text clipped - 11 lines]
>
> pieter

Reply to this Message

Pieter - 10 May 2008 12:33 GMT

Thanks Cor, I'll give it a try! :-)

How are you doing?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...