How to set up a linked server to DBase

[King David]

I am running an application that will be reading from several datasources,
that requires many transformations.

I am able to import the data using DTS, but the maintenance is too tedious
for the amount of data being imported.

I want to use Linked Servers, where they have worked very well for me in
working with other SQL Servers, Access and FaxPro Data.

However, I cannot seem to find documentation on hooking up to DBase
datasources. I'm interested in using sp_addlinkedserver or the Enterprise
Manager.

Any help? greatly appreciated

[Keith Kratochvil]

King,
Does something like this work for you?

EXEC sp_addlinkedserver
'DBFs',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'F:\DBFs', --location of the dbf files
NULL,
'dBase IV'
GO

exec sp_addlinkedsrvlogin
@rmtsrvname = 'DBFs',
@useself = false,
@locallogin = NULL,
@rmtuser = NULL,
@rmtpassword = NULL
go

/*
If the name of the dbf file is users.dbf
you would issue
SELECT * FROM DBFs...users
*/

--
Keith, SQL Server MVP

"King David" <db...@strongsys.com> wrote in message
news:evk3mQ0JCHA.2688@tkmsftngp11...

[King David]

That works fine, thanks. I actually spent several hours trying to find this.
For anyone else who may be desperately seeking help on LinkedServer Settings
check out this link.
http://www.mssqlserver.com/faq/development-hdqexamples.asp

"Keith Kratochvil" <keith.krato...@novusprintmedia.com> wrote in
message news:ejNVep0JCHA.2580@tkmsftngp11...

[Keith Kratochvil]

Or they can search Google's archive of the newsgroups....

http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver

--
Keith, SQL Server MVP

"King David" <db...@strongsys.com> wrote in message

news:#2o8$y0JCHA.2404@tkmsftngp11...