Re: Hyperscript-How to convert ascii format to .wkz format?

->From: Cynthia Leong <cynthia@hpsgcip1.sgp.hp.com> ->Subject: Hyperscript-How to convert ascii format to .wkz format? ->To: informix-list@rmy.emory.edu ->Date: Mon, 14 Mar 94 15:39:18 EST -> ->Hi fellow netters, -> ->This is two questions for those who is familiar with Hyperscript V1.0. -> ->Background : ->My existing data is in excel, lotus and ascii format and would like ->to load those data into my Online Engine. Informix Tech Support suggested ->to me to use Hyperscript to do the task. -> ->Questions : ->1.I have an ascii file with columns separated with space. I would like ->Hyperscript worksheet to read this ascii file and put them into ->the spreadsheet column and rows appropriately.Then with this data ->I would like to insert them into a table in the Online Database. -> ->2. Altenatively, is there anyway Hyperscript worksheet to be dump ->as informix Online engine ascii format? I gather this would be a faster ->way to insert data into Online than having a solution as (1). -> ->Thanks in advance for your effort to answer these questions. -> ->Cheers, ->Cynthia Leong If your ASCII data is in fixed width columns, which is typical of output from excel, lotus, etc., you might find it easier to use the Informix utility DBLOAD and bypass Hyperscript completely. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\