RE: SQL query to open OLEDB or ODBC to VFP?
From: Christopher D (ChristopherD_at_discussions.microsoft.com)
Date: 10/18/04
- Next message: Anders Altberg: "Re: GROUP BY Clause Problem in VFP8"
- Previous message: Steve Meyerson: "Re: GROUP BY Clause Problem in VFP8"
- In reply to: Tom Edelbrok: "SQL query to open OLEDB or ODBC to VFP?"
- Next in thread: Remus: "Re: SQL query to open OLEDB or ODBC to VFP?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 18 Oct 2004 02:57:02 -0700
Hi Tom,
you can also schedule a DTS package in SQL Server to import data from VFP at
a schedule you specify. I've done this several times.
You are better off using the VFPOLEDB-driver since it's more stable than the
ODBC-driver.
Just use Import Data, and follow the wizard.
Regards
Christopher D
"Tom Edelbrok" wrote:
> Is it possible for a SQL query or Stored Procedure to open a database at an
> external location via OLEDB or ODBC? What I want is for SQL to grab some
> data from Microsoft's Visual Fox Pro 8.1 and store it into a SQL table. I
> want this to happen about every minute or so.
>
> Thanks for help in advance,
>
> Tom Edelbrok
>
>
>
- Next message: Anders Altberg: "Re: GROUP BY Clause Problem in VFP8"
- Previous message: Steve Meyerson: "Re: GROUP BY Clause Problem in VFP8"
- In reply to: Tom Edelbrok: "SQL query to open OLEDB or ODBC to VFP?"
- Next in thread: Remus: "Re: SQL query to open OLEDB or ODBC to VFP?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
