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