Hi Scott, On Fri, 8 Nov 2002 09:13:38 -0800, you wrote: >Probably the easiest way to do it is to create an comma delimited ASCII >file with an extension of '.CSV'. This is a recognized excel extension >and just double clicking the created file will open it in excel. You can >use straight SQL to create the comma delimited file, so you can stop >quelling over the all the excel modules that you think you might need. >Try something like this: > >SELECT your_fields_here INTO OUTFILE 'your_filename.csv' FIELDS >TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" >FROM your_tables_here WHERE your_where_statements_here > Great. I was almost there but that got me safely to the destination. Thanx
I have another excel question which I will ask here just in case we have any excel gurus lurking in the shadows. Column a contains numeric data, say 100,101,102.....etc In another column I want to put a web link in the form of www.mysite.co/images/xxx.jpg where xxx is the value in column a of the respective row. I guess I need some form of concatenation but I can't figure the syntax. Anyone any ideas ? regards melanie ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:wdvltalk-join@;lists.wdvl.com Send Your Posts To: [EMAIL PROTECTED] To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
