change the file name to file.csv then it will put the data in separate columns accordingly.
 
 
2nd  answer
 
Create a template in excel and use the data feature to load your data.
 
Change the setting to refresh the data everytime it is opened.
 
out file.txt
unload data from tablename using collist as csv where...
out screen
 
launch filename.xls(when it opens it refreshes the data)
 
 
done
 
Dan
 
 
 
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bernard Lis
Sent: Monday, April 15, 2002 1:58 PM
To: [EMAIL PROTECTED]
Subject: Launching Excel 6.5++ 1.851 win

I did the following:
 
out file.xls
unload data from filename using col1,col2,col3 as csv where ....
out screen
launch file.xls
 
I got all the data but into one cell, separated by commas.
Is there a way to do this and put the data in seperate cells?
Or is there a way to call a preset sreadsheet along with file.xls?
 
I can make a spreadsheet to receive the data, then import using Excel's import, but I don't want the user to have to do this if possible.
 
Bernie Lis
Megabytes, Inc.
 
 

Reply via email to