By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,887 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,887 IT Pros & Developers. It's quick & easy.

translate xls to xml

P: n/a
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks
Nov 20 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks


Nov 20 '05 #2

P: n/a
But it's in vb.net program who the entry file is xls file and this program
work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks

Nov 20 '05 #3

P: n/a
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells. From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this program
work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:
Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks


Nov 20 '05 #4

P: n/a
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it
to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells. From there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
Please post this in the excel newsgroup.

Benny

Bruno wrote:

> Hi
>
> I have excel file and I used xml database.The problem is that I would > transfered all data of excel files in my db.
> It's possible but I don't know how.
>
> Thanks
>
>



Nov 20 '05 #5

P: n/a
Top Answer.

Sometimes ( but not often ) even I get carried away with redirecting
questions.

Regards OHM
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells.

From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this

program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
> Please post this in the excel newsgroup.
>
> Benny
>
> Bruno wrote:
>
> > Hi
> >
> > I have excel file and I used xml database.The problem is that I would > > transfered all data of excel files in my db.
> > It's possible but I don't know how.
> >
> > Thanks
> >
> >
>



Nov 20 '05 #6

P: n/a
Thanks lot,
i try it now

"Jeff Molby" <JeffMolby@C_mc_st.n_t> a écrit dans le message de
news:%2***************@TK2MSFTNGP12.phx.gbl...
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it to your XML file.
"Jeff Molby" <JeffMolby@C_mc_st.n_t> wrote in message
news:eq**************@TK2MSFTNGP11.phx.gbl...
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells.

From
there it's just a matter of deciding where in your xml database to put the
data.
"Bruno" <bo*************@wanadoo.fr> wrote in message
news:e3**************@TK2MSFTNGP11.phx.gbl...
But it's in vb.net program who the entry file is xls file and this

program work with a database xml( type dataset).
"Benny Mathew" <be***@mvps.org> a écrit dans le message de
news:O0**************@TK2MSFTNGP12.phx.gbl...
> Please post this in the excel newsgroup.
>
> Benny
>
> Bruno wrote:
>
> > Hi
> >
> > I have excel file and I used xml database.The problem is that I would > > transfered all data of excel files in my db.
> > It's possible but I don't know how.
> >
> > Thanks
> >
> >
>



Nov 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.