Hi Allan,

I've tried this :

Data Source : Driver do Microsoft dbase(*.dbf)

The error I got :

Hresult of 0x80004005(-2147467259) returned
Unexpected error occurred. An error result was returned
without an
error message.

and I've tried the one you adviced and got an error too.I
don't know
what I'm missing here.

Please any other advice ?

Thanks again , Ray.

The error you are getting is that Access is denied or that the files you
requested simply are not there. Can you set up a DSN to the Foxpro ? Files?
Does it work ?

Are you running this interatively or through the Agent Scheduler ?

Make sure you are using the Visual Foxpro ODBC driver.


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ray." <rfmdez (AT) yahoo (DOT) com> wrote