>>>I have an application in which I use Word as the destination of all reports. All data ends up in tables in Word docs. I started out transferring data from VFP to Word through Excel, which had acceptable performance, but need to change that, as Word appears to need Excel (or at least some tools) to import the Excel spreadsheet. I cannot require the user to have Excel.
>>>
>>>Do you have a quick way of transferring lots of data from VFP into Word tables? I have tried a cell by cell approach but it takes an unacceptable amount of time. I need a generic routine that does not require knowing the table layout, and allows any ordinary data type. Delimited files don't work either, as VFP adds quotation marks around character data and Word does not strip them out. Can XML be used in any way?
>>>
>>>Thanks for the help,
>>>Isabel
>>
>>Isabel,
>>If your data doesn't have memo fields then fastest way I know of is to copy to a tab delimited file, open in word and ConvertTextToTable.
>>If it has memo than you could either first write to a text file lowlevel and again open in word, convert to table or make an ADO connection to your table (slower then another approach of saving as HTML and opening in word).
>>If Excel is an option too then do not try HTML approach.
>>Cetin
>
>
>Cetin --
>
> What problems have you had importing HTML tables in Excel?
>
>
> Jay
Formatting. If you have a memo field it spoils the whole table. OTOH it might be the way users want to see in Excel.
Cetin