Forum Discussion
Ravik
10 years agoSuper Contributor
Hi Srikala Gudavalli,
I don't understand, for reading data from excel why you create -
'1) Create an ADODB connection and recordset
2- Open connection'
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & sFileName & ";" & "Extended Properties=""Excel 8.0;HDR=Yes;"";
3)- Create a Recordset'
'4) Execute SQL and store results in reocrdset'
have you used Open Office instead of Microsoft Office or using "Office Starter" .
because normally we want to work with Microsoft Office (Excel) we can create object of Excel like below
Set Exo = CreateObject("Excel.Application") ot
Set Exo = Sys.OleObject("Excel.Application")
Exo.Workbooks.Open("Excel File Path")
.
.
.
.
Could you please share/Explain it in more.
Thanks
Ravik
I don't understand, for reading data from excel why you create -
'1) Create an ADODB connection and recordset
2- Open connection'
objConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & sFileName & ";" & "Extended Properties=""Excel 8.0;HDR=Yes;"";
3)- Create a Recordset'
'4) Execute SQL and store results in reocrdset'
have you used Open Office instead of Microsoft Office or using "Office Starter" .
because normally we want to work with Microsoft Office (Excel) we can create object of Excel like below
Set Exo = CreateObject("Excel.Application") ot
Set Exo = Sys.OleObject("Excel.Application")
Exo.Workbooks.Open("Excel File Path")
.
.
.
.
Could you please share/Explain it in more.
Thanks
Ravik
Related Content
- 4 years ago
- 6 years ago
Recent Discussions
- 13 hours ago
- 2 days ago