I am using this:

.....
ConnectionString="ODBC;DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=c:\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;"

sqlquery="SELECT * FROM c:\foxwork\vfpapps\syserr.dbf"

ObjExcel.ActiveSheet.QueryTables.Add(;
ConnectionString,;
ObjExcel.ActiveSheet.Range("A1"),;
sqlquery).Refresh
....

>I saw the answer to this awhile ago and thought I saved it for future reference....now the future is here and I can't find it!
>
>I am using the COPY TO command to export records to an Excel spreadsheet but I also need to export the text in the memo field for each record. I know there was a limit of 254 chars on the workaround, and that is fine.
>
>Can someone refresh my memory?
>
>tks,