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.

Tags:
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',

@srvproduct=N'DBF',

@provider=N'Microsoft.ACE.OLEDB.12.0',

@datasrc=N'c:\dbffiles',

@provstr=N'dBASE IV'

EXEC master.dbo.sp_addlinkedsrvlogin

@rmtsrvname=N'DBFSERVER',

@useself=N'False',

@locallogin=NULL,

@rmtuser=NULL,

@rmtpassword=NULL

-----------------------------------------------------------------

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

Regards,

Elton de Freitas

0 View this answer in context

Helpful Answer

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