Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Import a set of DBF files in Data Services

Hello Experts,

I need to import some DBF files in the Data Services.

In each load (monthly), this files change the name and the  quantity.

Any suggestion?

Thanks for listening.

Former Member
Former Member replied

Hi experts,

Thank you for your suggestions, I managed to make the process using Linked Server in SQL Server.

I also tested it with Openrowset and it worked, but i had to use the 'Microsoft.ACE.OLEDB.12.0' driver because the 'vfpoledb' driver generated an error.

My example with openrowset:


select * from openrowset('Microsoft.ACE.OLEDB.12.0',

'dBASE IV;Database=C:\DBFFILES\','SELECT * FROM process')


*** A small problem we noticed was the file name limit eight characters.

In my example, the name is process.

My example with linked server:


EXEC master.dbo.sp_addlinkedserver

@server = N'DBFSERVER',




@provstr=N'dBASE IV'

EXEC master.dbo.sp_addlinkedsrvlogin







Searching the internet, I saw that many people have this problem with the driver 'vfpoledb'.


Elton de Freitas

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question