When I had to get records out of an Access tables I just created a DBC and a remote view connecting to the Access table. Then I was able to just open the view and copy it to a FoxPro table.

Of course I just need to do it once and not write this functionality into a program.

Aloha,

James
>Hello Everyone,
>
>I need to extract records out of MS Access tables.
>What is the best way to do this?
>I can:
> Open Access * oleApp = CREATEOBJECT("Access.Application")
> Control it's visability * oleApp.Visible = .T.
> Open a database * oleApp.OpenCurrentDatabase(Openmdb, .T.)
> Enumerate all it's tabels * FOR EACH CurrentTable IN _
> oleApp.CurrentData.AllTables
>
>But I cannot get oleApp.DoCmd.TransferText to work.
>
>Thanks for the help,
>Gaylen