bb.donnay-software.com

Roger,

Just noticed something. Had a client running a process at night on server using the scheduler, no excel installed or available. Sending an excel file to his customer on daily activity via email. We were using csv but he did not like the non-formatted fields. We just tried just sending the dbf file, but renamed it to .xls format. Excel opened without a problem with the proper formatting.
Never knew we could do that by just renaming, although in our system the user normally want to open the spreadsheet when created.

Fred
Omni

You don't even have to rename it. Excel just opens dbf. It has its own Converter. Versions of Excel before 2007 and recorded the xls file as dbf (save as), and later versions cannot.

Knew that, but emailing it to a 3rd party could be an issue, but at the least it would be confusing..they would not know what a dbf file is, and unsure if their email would block it. Or, if they clicked to open their windows system would not know what to open it with

Fred

Everything is as you say

That is interesting to know that a DBF can be renamed as XLS and Excel will open it. Thanks.