x6 vba 7.1 excel connection problem

[olympiatr]

hi all,

it was workin on x5, codes are like that;

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & ExcelAdi & ";" & "Extended Properties=""Excel 8.0; HDR=YES;"""

but now in x6 x64 v. (x64 win 7 based machine) not workin. any idea?

regards

[SteveDude]

It's my understanding Microsoft's Jet Engine is not supported in x64. I'm not that familiar with its use in VBA, but in other languages it can only be used when apps that are built as 32 Bit.

There are alternatives in .NET, but I am not familiar with what VBA supports.

May be wrong but my guess is it will work fine in the 32 Bit version of X6 along with the 32 Bit version of office.

[olympiatr]

hi Steve,

thnx for interesting. i will try over x64 (i have to)

[SteveDude]

You might take a look at this link...

http://www.altova.com/Access-Databas...bit-64bit.html

I can say that you will need to work with x64 to x64 Excel. Not really a way for a 64 Bit app to connect to a 32 Bit one.

[shelbym]

Using 64bit CorelDRAW and 64bit Excel you can use:

    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""

-Shelby

[olympiatr]

Thnx dear friend, i will try over it. Thnx for interest.

[SteveDude]

Originally Posted by shelbym

Using 64bit CorelDRAW and 64bit Excel you can use:

    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""

-Shelby

The only real bummer about this is, if a user has a 32 Bit version of office installed, it has to uninstalled for the 64 Bit OLEDB driver to work or even be installed. The only way around this I have found is by using SQL Server.

[olympiatr]

Originally Posted by shelbym

Using 64bit CorelDRAW and 64bit Excel you can use:

    cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=D:\Temp\Sample.xlsx;" & _
             "Extended Properties=""Excel 8.0; HDR=YES;"""

-Shelby

appears error:

couldn't find provider. may not installed correctly (surely i changed the excel address in your code. my corel v x6 and machine W7 x64)

Dim cnn As New ADODB.Connection
cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=c:\Tunc\Knorr.xlsx;" & _
"Extended Properties=""Excel 8.0; HDR=YES;"""

[olympiatr]

Originally Posted by SteveDude

The only real bummer about this is, if a user has a 32 Bit version of office installed, it has to uninstalled for the 64 Bit OLEDB driver to work or even be installed. The only way around this I have found is by using SQL Server.

i think office is 32 bit. i will try over x64 office then. thnx for interest.