To transfer data from vfp to excel, I do like this...
oXLS = createobject("Excel.Application")
oXLS.application.displayalerts = .F.
loWorkBook = oXLS.application.workbooks.open(lcTemplateFile)
oXLS.activesheet.range("A6").select
oXLS.activesheet.paste
loWorkBook.saveas(lcFichier)
oXLS.application.quit()
The command COPY TO also truncated memo field.
I want to know how to transfer via MS-Access?