469,076 Members | 1,340 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

Passing a Parameter through an OpenRowSet

4
My code is as follows:

Expand|Select|Wrap|Line Numbers
  1.     SELECT  * INTO TempTable FROM OPENROWSET(
  2.        'MSDASQL',
  3.        'Driver={Microsoft dBase Driver
  4. (*.dbf)};DBQ=Q:\TestData\tdsv\SIW\',
  5.        'Select * from REFCOLR')
  6.     WHERE COLOR IS NOT NULL
I need to replace "Q:\TestData\tdsv\SIW\" with a Parameter which gives the location of the .dbf files. Any ideas on how this is done???
May 10 '07 #1
0 1257

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Mahesh Hardikar | last post: by
11 posts views Thread by John Pass | last post: by
reply views Thread by amazon | last post: by
12 posts views Thread by dave_dp | last post: by
2 posts views Thread by Gugale at Lincoln | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.