Thanks alot. It worked great!
I can go to sleep now!
Chris
>This works for me. Notice double semicolon and the table name w/o quotes.
SELECT *
>FROM OPENROWSET('VFPOLEDB.1','D:\MyDbc.dbc';;, MyTable)
>
>
>
>>I am trying to open a VFP table using the VFP oledb driver within SQL Svr 2000
>>I can't seem to get the syntax quite right.
>>Here is what I am trying:
>>SELECT *
>>FROM OPENROWSET('VFPOLEDB.1','D:\MyDbc.dbc";"MyTable')
>>
>>Does anyone know the proper syntax for this?
>>
>>Thanks,
>>
>>Chris
Chris