In one of my VFP applications I want to move data from VFP to Access.
I have found out how to get the data into Access but only as a linked table. I do this with the following source:
oAccess = CreateObject("Access.Application")
oAccess.newcurrentdatabase(pcCopyTo)
oDb = oAccess.CurrentDb
oTable = oDb.CreateTableDef(pcCopyFile)

* Link
oTable.Connect = "DBase IV;DATABASE=" + pcCopyFrom
oTable.SourceTableName= pcCopyFile+ '.dbf'
oDb.TableDefs.Append(oTable)

This works quite nicely but it only links the table. I want to import it into Access. Going through the help-files has brought me nowhere. Can anyone tell me how this can be done?

Any help is appreciated.

Regards,

Ron Brahma