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

Jun 27 '08 #1

Subscribe Post Reply

1970

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/libr...19(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" <pi****************@hotmail.comschreef in bericht
news:eK**************@TK2MSFTNGP06.phx.gbl...

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

Jun 27 '08 #2

Pieter

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

How are you doing?

Jun 27 '08 #3

Similar topics

Excel - Read-only

by: newtophp2000 | last post by:

I created a system DSN for an Excel file and I have been using it for a while. I can read from it as well as update it. (The Excel file includes weekly updates to some records.) Then I tried...

Microsoft SQL Server

How to read data from an excel file by C?

by: QQ | last post by:

I am trying to read data from Excel files I use the following codes, however, it didn't work Can anyone tell me what the format excel files have, what I should do to read it from C? Thanks a...

C / C++

How To Read Excel Files In Python?

by: Anand | last post by:

Hello, Can I get some help on how to read the excel files using python? from win32com.client import Dispatch xlApp = Dispatch("Excel.Application") xlWb = xlApp.Workbooks.Open("Read.xls")...

Python

How to read/import an excel file programmatically to a db?? help

by: Reza Solouki | last post by:

Hello, I never had to do anything with office tools programmatically till now(I guess there is first time for everything), so this might be a very silly and simple question for some of you. Any...

ASP.NET

Attempted to read or write protected memory

by: Seok Bee | last post by:

Dear Experts, I have created a script to extract the Event Logs from the system into an excel sheet. The logs are separated into 2 worksheets (Application Log and System Log). After this excel...

Visual Basic .NET

pyExcelerator - Can I read and modify an existing Excel-WorkBook?

by: Marco Aschwanden | last post by:

Hi I would like to 1. import an existing Excel-sheet (a template) 2. and add some data to it 3. and save it under a different name afterwards. To me it seems, that pyExcelerator does not...

Python

how to read cell data line by line from excel using vb script in macro?

by: ashok0866 | last post by:

I had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel. The issue...

ASP / Active Server Pages

read a excel sheet using aspose.excel

by: sajithkahawatta | last post by:

is there any one used aspose.excel i used automation to read a exel doc .but we have to install ms excel to do that so i suppose to use aspose.excel can any one give me the 'Aspose.Excel.dll' and...

ASP.NET

read images/graphics in spreadsheet

by: wstsoi | last post by:

hi I have to read images from spreadsheet, is it possible to do with php?

PHP

cant read in excel data?

by: jagguy | last post by:

Hi, i cant read in data from excel 97 using vb.net 2003. I get an exception error . all i want to do is read in values from excel initially. I want to just test it using msgbox. Dim XL...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server