How to create .WK1 files?
Posted in 1994
Topics: Installation, Setup & Upgrades
Stu Miller wrote .... Hi, Bit of a newbie question for you. First of all, I am not a programmer but I am responsible for installing and configuring (basically writing a bunch of ACE reports and database definition) a "mission critical" application (a Laboratory Information Management System or LIMS) sold to us by a 3rd party in the U.S. One of the requests from our clients is for data files (reports) from the system in Lotus .WK1 format. Remembering that I am not a programmer but an adept hacker, is it possible to create a report that writes output to a file in .WK1 format or does this require some fancy C application(s)? Any advice or leads to pursue on this would be greatly appreciated. TIA, Stu -- Stu and all, You don't have to go to C. Instead, you should consider the following options: 1.- Put your output into a "simple" comma-delimited ASCII file. Lotus (and most) spreadsheets can "easily" import this format. 2.- Use a Microsoft Access front-end, and attach your database to it. MS-Access provides a "TransferSpreadsheet" action as part of Access Basic. Use this to export your attached data to an appropriate spreadsheet file. 3.- If you prefer, you might also look into Visual Basic. You might be able to provide something a little smaller and faster, but at the expense of more development time. Hope this advice is helpful. Dave Finley finleyd@vrinet.com