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