I don't want to use any other tool, I just want to programmatically use vfpoledb to import data from a dbf file. I have downloaded and used the vfpoledb driver in applications but whenever I try to use it in my stored procedure it says vfpoledb is not registered. Here is my code.
SET
ANSI_NULLS ON
GO
SET
QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE
PROCEDURE
spImportDB
-- Add the parameters for the stored procedure here
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET
NOCOUNT
ON
;
-- Insert statements for procedure here
-- Get the folder that stores the MOM tables
SELECT
* into
MyNewProducts
FROM
OPENROWSET
('vfpoledb'
,'C:\Users\Adm\Desktop\DBF'
,
'SELECT * FROM DbfProducts'
)
END
GO
and here is the error:
Msg 7403, Level 16, State 1, Procedure spImportDB, Line 17
The OLE DB provider "vfpoledb" has not been registered.
I've also tried using vfpoledb.1 and that didn't work either.
Any help would be greatly apprciated. This is really making me angry. Also when I go to DTS and import data that way I can use the Microsoft Fox Pro Driver for OleDb without any problems but not when I use the openrowset, so I figure it's something in my syntax or what I'm not passing in to the function. help...thanks
john.strez
