Re: adodb.Connection execute to Excel 12.0 from vb script
- From: "Norman Yuan" <FakeName@xxxxxxxxxxxxx>
- Date: Thu, 10 Apr 2008 07:23:34 -0700
In your code, if you code the ConnectionString like:
sconn = "Provider=Microsoft.ACE.OLEDB.12.0;...."
then, the running computer must have either MS Access2007 installed, or MS Office Aceess Database Engine 2007 installed.
Are you sure your ConnectionString uses "Microsoft.ACE.OLEDB.12.0;...."?
"Per" <Per@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5C41986D-8B02-40F3-BDDC-87B22D68A3B4@xxxxxxxxxxxxxxxx
Thanks for your help Norman. But this problem is very strange, i have talked
with the company that manage my clients computers. My solution works on half
of their pcs. they are running a microsoft installation program. They do not
have any clue why it sometimes work and sometimes dont. And i do not know
what dlls to look for if maybe they are not properly registrered? I do not
think Acces engine is installed, but still it works on half of their
computers. Any clues?
regards,
/Per
"Norman Yuan" skrev:
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.
>>
>>
.
- References:
- adodb.Connection execute to Excel 12.0 from vb script
- From: Per
- Re: adodb.Connection execute to Excel 12.0 from vb script
- From: Norman Yuan
- Re: adodb.Connection execute to Excel 12.0 from vb script
- From: Per
- Re: adodb.Connection execute to Excel 12.0 from vb script
- From: Norman Yuan
- Re: adodb.Connection execute to Excel 12.0 from vb script
- From: Per
- adodb.Connection execute to Excel 12.0 from vb script
- Prev by Date: Re: Word 2003 Macro frustration
- Next by Date: Re: Word 2003 Macro frustration
- Previous by thread: Re: adodb.Connection execute to Excel 12.0 from vb script
- Next by thread: create a cutomXML
- Index(es):
Relevant Pages
|
Loading
