bulk insert dbf file

[Guest_imported]

hi guys
i want to copy data from branch.dbf into table branch
please help me to do it.
i am using

BULK INSERT betatest.dbo.[branch]
FROM 'c:\betagrp\dbf\branch.dbf'
WITH
(
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\t\n')
it give erros

 

[tlbroadbent]

Bulk Insert works on text files. Is the DBF file a text file of a database file from another RDMS or database program? If it is you'll need to use DTS to copy the file using ODBC or OLE DB. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.