VBA SQL - variable Source Data...

S

SpeeD

Hi.

I'm new a this Excel/Sql thing. so bare with me :)

My my problem is that i need to add several different (variable) SQL queries
to my WB so i´ve add the following with no success:

Cam = ActiveWorkbook.Path & "\" & "JB.xls"
...
..Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Data Source=CAM;Mode=Share De"

it only works if i specify the complete path, not variable
..Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Data Source=D:\TRABALHOS\2010\Março\JB.xls;Mode=Share De"

How can a make my variable with the Path work?

Thanks for reading this

SpeeD
 
B

Bob Phillips

..Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Data Source=" & CAM & ";Mode=Share De"
 
S

SpeeD

Thanks a lot Bob!
It works! :)

SpeeD

Bob Phillips said:
..Connection = Array("OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;User
ID=Admin;Data Source=" & CAM & ";Mode=Share De"

--

HTH

Bob




.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid internet address 1
VBA Excel data to SQL Sever table 1
I want Excel to determine the correct directory. 10
Chartspace Data Source and Connection String Problem 0
Data query refresh problem with changing filenames 1
Can't change connection property on querytable 4
how do I close the connection from excel to access after refresh? 0
Problems importing data from a *.dat file 1

Top