sql server odbc: I am trying to import .dbf tables from Fox Pro imto SQL
SELECT *INTO #People FROM OPENROWSET
('MSDASQL', 'DRIVER={Microsoft fxopro vfp Driver
(*.dbf)};SourceDB=q:\Learnast\dbfs','SELECT * FROM people')

here is the error message I receive

OLE DB provider "MSDASQL" for linked server "(null)" returned message
"[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for

Hi!

Have you tried the FoxPro and Visual FoxPro OLE DB data provider,
downloadable from msdn.microsoft.com/vfoxpro/downloads/updates ? You can set
up a linked server and then just use code like "Select Whatever From
LinkedServerName...TableName" . (Note three dots between server and table
names.)

Here's what works for me to set up the Linked Server in SQL 2005 using the
Linked Server dialog:

Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Northwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.


--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com



"HelpVisualFoxProPerson" <HelpVisualFoxProPerson@discussions.microsoft.com>
[quoted text, click to view]