Linked server

HI,
Thanks for this.
I got a error when
SELECT * FROM DBFs...motclm02
The error was:

Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
I figure it must be a driver related.
I have successfully opened with openrowset as:

SELECT COM, ICODE1, ICODE2, ICODE3, ICODE4, ASSCOD, INSREF, CATCOD, BAR,
BRK, CLS, NUM, IYR, DET, DOL, DREP, STATUS, DFIN, DRV, VEH, REG,
PERIL, RESOURCE, CAUSE, FAULT, MD, MEA, BI, TPFN, OTFN, EST1ST, LEGAL,
OTHER, REC, RECPD, SAL, ASSZR, ASSIN, UXSOD, UXSTP, UXSOT,
OXSOD, OXSTP, OXSOT, OATYPE, PXSOD, PXSTP, PXSOT, BPCODE, BPNUM, TOT, UXSD,
UXST, UXSO, OXSD, OXST, OXSO, PXSD, PXST, PXSO, ZR1,
NOT1, INSGRP, INSPOL, UNS, ZR1TOT, ZRATOT, NOTTOT, CCODE1, CCODE2, CCODE3,
CCODE4, VAT, VATASS, VATTOT, VATATOT, BORDCODE,
AUTH_BY, MOD_BY, LAST_MOD
FROM OPENROWSET('MSDASQL', 'Driver={Microsoft dBase Driver
(*.dbf)};DBQ=C:\Work\MRG\Motor\', 'Select * from motclm02.dbf') AS motor

Could you perhaps relate how I would use linked server using the above
drivers. I am uncertain as to how to set that up

Thanks
Robert

"Hari Prasad" wrote in message

> Yes, it is possible. Take a look into the old archive.
>
>
http://groups.google.com/group/microsoft.public.sqlserver.programming/...wse_frm
>
> Thanks
> Hari
>
> "Robert Bravery" wrote in message
>
> > HI,
> >
> > Is there a way to create a linked server to dbase files.
> > I need to be able to import data from dbase files on a regular basis,
once
> > the data has been imported it then needs to go through a verification
and
> > transformation, then finally imported to the correct table.
> > I thought of using DTS, but have heard that it is slow. Then sombody
> > mentioned linked servers.
> >
> > But if htat does not work, does any one have any other sugestions that I
> > can
> > persue
> >
> > Thanks
> > Robert
> >
> >
>
>
 >> Stay informed about: Linked server