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

If ther is no Access2007 installed, it is likely the computer does not have MS ADE OLEDB 12.0 provider installed.

You can go to "Add/remove programs" window to verify it: if installed, you should be able to find one item called "Microsoft Office Access database engine 2007".

To download it:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en



"Per" <Per@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5F7550F0-2D24-4188-BC76-A6DC22507E95@xxxxxxxxxxxxxxxx
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: Need Help: Operating system error 3706
    ... Installing an additional component resolved the problem and the software is now able to connect to the database ... The developer is currently doing a complete rewrite/update of the program, including database functions. ... While this would require a modest re-write, it's not that tough to convert to a managed-code provider instead of the COM-based OLE DB provider. ... If the application is not based on .NET, then make sure the application is upgraded to use the SNAC (SQL Server Native Client) provider which is less trouble-prone than the older MDAC-based providers. ...
    (microsoft.public.sqlserver.connect)
  • Re: SMS 2003 server not discovering clients.
    ... I have selected to extend to extended Active Directory while installing SMS ... Provider Version: 2.50.3174.1003 ... to server. ...
    (microsoft.public.sms.admin)
  • Re: TSP for Ericsson MD110 CT Adapter
    ... The problem has been resolved by installing a newer version of the TSP ... documented TAPI using the TAPI browser. ... We are using the CT Adapter to ... the MD110 provider remains in the provider list but is not available ...
    (microsoft.public.win32.programmer.tapi)
  • Re: Im paying ATT for a 6 meg down load speed but Im not even getting 1 meg can any one help me fix
    ... meg can any one help me fix this. ... Any time I down laod someting I ... I was thinking about installing a ... you probably need to call your provider. ...
    (comp.dcom.sys.cisco)
  • Re: SQLMobile Native OLE DB App Fails to Open database
    ... Installing isqlw to my device and then ... Help file from MS.....it makes no mention of any additional required ... app is targeted as a free web download. ... and registering the provider without a single hiccup. ...
    (microsoft.public.sqlserver.ce)
Loading