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

 

[Phoebe.]

Thanks Cor,

How can i file my excel data into dataset then?

Any example on this? Thanks again.

 

[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.

 

[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/d...tskcodeexamplereadingexceldataintodataset.asp

I hope this helps a little bit?

Cor

 

[Phoebe.]

Thanks 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/default.asp?url=/library/en-us/dv_vbcode/h
tml/vbtskcodeexamplereadingexceldataintodataset.asp

I hope this helps a little bit?

Cor