Hi Jim,
You can create a linked server to VFP data as shown in
Re: SQL Server 2000 Linked Server to Visual FoxPro Message #
916251.
>I'm trying to get an SQL INSERT command to work that uses the OPENROWSET function but I get the following error message back from MS SQL Server:
>
> Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Ad
> hoc access to OLE DB provider 'VFPOLEDB' has been denied. You must
> access this provider through a linked server.
>
>The SQL command that I submit with SQLEXEC() is:
>
>INSERT INTO Messages SELECT *
>FROM OPENROWSET('VFPOLEDB', 'C:\MyDev\dBXSystems\Data\VisiPak.dbc';'';'',
>'SELECT * FROM Messages ORDER BY PrimeKey')
>
>My MS SQL Server 2000 is running on my workstation. Any help would be greatly appreciated.
>
>Jim White
--sb--