Re: adodb.Connection execute to Excel 12.0 from vb script

the file is xlsx. the computers does not have access2007 installed.
i have also tried with Jet oledb provider against an xls file with the same
result.

it seems like i can open the connection but not execute my sql to my
recordset.

what dll files should i look for so i know that everything is in place?

"Norman Yuan" skrev:

Are you reading from Excel 2007 file (*.xlsx, *.xlsm...)? Does the running
computer has Access2007 installed (hence Microsoft.ACE.OLEDB.12.0 provider,
which does not come with OS as old Jet Engine, you need to have it by
installing Access2007, or download it from MS).

If it is regular *.xls file (Excel2003 or older), try to use old, good Jet
OLEDB provider and set "Extended Properties=Excel 8.0;"


"Per" <Per@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAC95956-A03C-4485-9D94-4E933C3352AB@xxxxxxxxxxxxxxxx
I am trying to get information about users from an excel file. i am having
problems with command execute. it worked perfectly before on my clients
older pcs which had office 2000 on but upgraded to 2007. now on a new
installed pc i get :"object required" when the script tries to execute the
command with the sql. I do not know where to start looking. what is
missing?
The OS is win xp pro and Office is 2007


CODE: set conn= Createobject("ADODB.Connection")
sconn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & sDBPath & ";"
& _
"Extended Properties=""Excel 12.0;HDR=YES"""


conn.open sConn

sSQL = "Select * from [Login$]"
set rsUser = conn.Execute(sSQL)


this is not returning any rows but it did before.


.

Relevant Pages

  • Re: Excel 2003 and Excel Viewer on a Terminal Server
    ... click on a link to an XLS file, ... which says "Installing" and then you see the standard DNS ... >I've never used the excel viewer or terminal services. ...
    (microsoft.public.excel.misc)
  • Re: Dao350.dll unsupported under Windows 7
    ... OS updates you don't need to worry about installing it. ... Jet 4.0 is that we have many customers now using our app with DAO 3.51 ... standard user account in Windows to ensure none of the Sandbox ...
    (microsoft.public.vb.general.discussion)
  • Re: Fun and games instaling VB6 and MSDN!
    ... it's apparently not a question of installing a subset of the help ... I've tried both Custom | All and Full separately to no avail. ... it only happens with a few keywords. ... (And yes I knew Jet was a database engine)*. ...
    (microsoft.public.vb.general.discussion)
  • Re: Dao350.dll unsupported under Windows 7
    ... OS updates you don't need to worry about installing it. ... Jet 4.0 is that we have many customers now using our app with DAO 3.51 ... standard user account in Windows to ensure none of the Sandbox ...
    (microsoft.public.vb.general.discussion)
  • RE: Excel and ADO .NET ... it made me cry now!!
    ... Also, after installing Jet again, error was still there. ... > the TEMP directory for the ASPNET account (Documents and ...
    (microsoft.public.dotnet.framework.adonet)
Loading