>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?
I don't know. I don't use Access.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
