>>>>>>>>>>>>
I would like every thing automated, run through VFP. I don't want to have to touch ACCESS at all. I trying to get data from a third party EDI program written in ACCESS. UGH!
>>>>>>>>>>>>
RJ -- just set up a connection via ODBC into the Access database, create views from the Access tables, then append from the view (or probably, series of views) into your VFP table(s).
ADO would work too, but unless you have other reasons to use it in your app, I'd stick with remote views.
Hope this helps.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell