VBA SQL - variable Source Data...
 

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

VBA SQL - variable Source Data...
 

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

--

HTH

Bob

"SpeeD" wrote in message
...
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

VBA SQL - variable Source Data...
 

Thanks a lot Bob!
It works! :-)

SpeeD

"Bob Phillips" wrote:


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

--

HTH

Bob

"SpeeD" wrote in message
...
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



.