copy to xl5 ole error

[robsuttonjr]

Somewhat strange...
Last night I upgraded a server using winnt 4.0 & office 97 to Windows 2000 with Office 2000. When I do a copy to ..xl5 I get an ole error. Keep in mind I am copying to a directory on the upgraded server. If I change the directory to my local path it works fine. When I use copy to xls to a path on the server it works fine. It is only when copying to xl5 on a path on the server that I get the ole error. So questions I have are do I need to install office 97 on the server? What is the difference between copy to xls and xl5? Which should I use? Is there a better copy to xl? ? Thanks!

The more I learn the more I find I know nothing.

Rob

 

[rgbean]

Rob,
That is indeed strange, because VFP doesn't care, know or actually use Excel in the COPY TO ... XL? command - it uses the known built-in formats of the acceptable file types.

What version and SP level of VFP are you using? Does this happen in the developer IDE or only using the runtime files with your .APP/.EXE? (Are you sure that the RT version and SP match the developers?)

What OS are you running under?

Rick

 

[robsuttonjr]

I am using Windows 2000 on the server and workstation. But it also happens on a Windows NT 4.0 workstation using fox 7. In ide or compiled app result is the same. The key is that when I am using XL5 when copying to a path on the upgraded server I get the error. I am going to install office 97 to see what happens.

The more I learn the more I find I know nothing.

Rob

 

[MarciaAkins]

Hi Rob.

>> What is the difference between copy to xls and xl5? <<

From the VFP 8.0 help file:

XLS
Creates a Microsoft Excel version 2.0 worksheet file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new worksheet.
Note Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows.
XL5
Creates a Microsoft Excel version 5.0 workbook file. Each field from the currently selected table becomes a column in the spreadsheet, and each record becomes a row. If you do not include a file extension, an .xls extension is assigned to the new workbook.
Note Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows.

Marcia G. Akins

http://www.TightlineComputers.com