Read Data from excel & save to recordset

[Phoebe.]

Hi, Good Day!

How can I read data from excel file and save them into a recordset?

Can someone help?
Thanks in advanced.

rgds,
Phoebe.

[Cor]

Hi Phoebe,

Here are connection strings you can use with Ado.net and then get your excel
file in a dataset.

Recordsets are not really used anymore if it is not for upgrading reasons in
VB.net you know.

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps a little bit?

Cor

[Jorge]

Hello Phoebe

Had a reference in the COM components of Microsoft Office
(Version Number) Object Library in your project. Create
an instance o excel application and add a book. Then use
the Book.Open(ExcelFileName) to open the excel document.
Them select the first sheet and sheet.range("A1").text to
read the value in cell A1.

Kind Regards
Jorge

-----Original Message-----
Hi, Good Day!

How can I read data from excel file and save them into a recordset?
Can someone help?
Thanks in advanced.

rgds,
Phoebe.
.

[Phoebe.]

Thanks Cor,

How can i file my excel data into dataset then?

Any example on this? Thanks again.
"Cor" <no*@non.com> wrote in message
news:uF**************@TK2MSFTNGP10.phx.gbl...

Hi Phoebe,

Here are connection strings you can use with Ado.net and then get your excel file in a dataset.

Recordsets are not really used anymore if it is not for upgrading reasons in VB.net you know.

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps a little bit?

Cor

[Phoebe.]

Thanks Jorge,

I want to open the excel file and display it in either datagrid or dataset
since i hv a few excel file with the same format but different data to be
display.

Can you help again.
Thanks.

"Jorge" <an*******@discussions.microsoft.com> wrote in message
news:58****************************@phx.gbl...

Hello Phoebe

Had a reference in the COM components of Microsoft Office
(Version Number) Object Library in your project. Create
an instance o excel application and add a book. Then use
the Book.Open(ExcelFileName) to open the excel document.
Them select the first sheet and sheet.range("A1").text to
read the value in cell A1.

Kind Regards
Jorge

-----Original Message-----
Hi, Good Day!

How can I read data from excel file and save them into a

recordset?

Can someone help?
Thanks in advanced.

rgds,
Phoebe.
.

[Cor]

Hi Phoebe,

I was typing it and did not know how where write the $(after or before) in
"sheet" and then I did look on msdn, the sample is there complete, the sheet
can be any tabpagename of course.

http://msdn.microsoft.com/library/de...ntodataset.asp

I hope this helps a little bit?

Cor

Thanks Cor,

How can i file my excel data into dataset then?

Any example on this? Thanks again.

[Phoebe.]

Thanks Cor.

"Cor" <no*@non.com> wrote in message
news:uP**************@TK2MSFTNGP12.phx.gbl...

Hi Phoebe,

I was typing it and did not know how where write the $(after or before) in
"sheet" and then I did look on msdn, the sample is there complete, the sheet can be any tabpagename of course.

http://msdn.microsoft.com/library/de...us/dv_vbcode/h
tml/vbtskcodeexamplereadingexceldataintodataset.asp
I hope this helps a little bit?

Cor

Thanks Cor,

How can i file my excel data into dataset then?

Any example on this? Thanks again.