>Would like to know if anyone is aware of a tool to export data directly from Oracle to VFP format
You can run it in 6 lines, aproximatly like this
Checkout filed with table name, if you need to export Oracle indexes, I can tell the code later, looking Oracle system table
=sqltables(con,'tb')
go top
do while not eof('tb')
m.sql='select * from '+tb.table_name
if sqlexec(con,m.sql)>0
copy to (tb.table_name)
endif
skip 1 in tb
enddo
You can also do it with sqsqlserver Enterprise manager with export tool
Best wishes, Vladimir Zhuravlev
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.