Re: Using openrowset to select foxpro table data through odbc ?
ksnsacc_at_hotmail
Date: 03/26/04
- Next message: Adam Machanic: "Re: Joins & Cursors"
- Previous message: Joe Celko: "Re: How to return column data as a single string?"
- In reply to: Luqman: "Using openrowset to select foxpro table data through odbc ?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Mar 2004 17:01:12 -0500
This seems to work:
SELECT * FROM OPENROWSET('MSDASQL', 'DSN_NAME'; ''; '', 'SELECT * FROM
TABLE') Rowset_1
"Luqman" <pearlsoft@cyber.net.pk> wrote in message
news:%23s62uIzEEHA.1152@TK2MSFTNGP10.phx.gbl...
> What is the syntax to use openrowset to select visual foxpro table data
> through odbc in query analyzer ?
>
> I have already created a system dsn and name it 'fox', with free table
> option (not using vfp database).
>
> I tried following to retrieve data from table name 'AGNFL01' but could not
> succeed.
>
> select * from openRowSet('MSDASQL','FOX','','','AGNFL01')
>
>
>
>
> Best Regards,
>
> Luqman
>
>
>
- Next message: Adam Machanic: "Re: Joins & Cursors"
- Previous message: Joe Celko: "Re: How to return column data as a single string?"
- In reply to: Luqman: "Using openrowset to select foxpro table data through odbc ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
