Dreamweaver - Export for Excel?

Author

Export for Excel?

Ulitasch

2004-08-26, 12:22 pm

I have Cocoa mysql for managing my databases. I just cannot figure out what I
have to put in:
fields terminated by (?) ,fields enclosed by (?), fields escaped by (?), lines
terminated by (?)
to export a table's content so, that I can import it in Excel.?
Thanks for helping me.

Murray *TMM*

2004-08-26, 12:22 pm

Comma separated values (if your fields contain commas, then enclose them in
quotes) is all you need, e.g.,

"field1","field2","field3", etc....

Separate your records with a carriage return, e.g.,

"field1","field2","field3", "field4", field5C/R
"field1","field2","field3", "field4", field5C/R

would be how two records with 5 fields each would look in the text file.

Note - a number enclosed in quotes, as above, will be interpreted as a
string by excel.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Ulitasch" <webforumsuser@macromedia.com> wrote in message
news:cgk90l$40h$1@forums.macromedia.com...
>I have Cocoa mysql for managing my databases. I just cannot figure out what
>I
> have to put in:
> fields terminated by (?) ,fields enclosed by (?), fields escaped by (?),
> lines
> terminated by (?)
> to export a table's content so, that I can import it in Excel.?
> Thanks for helping me.
>

Joaquim Lopes

2004-08-26, 12:22 pm

Choose Export > Table Content Result > CSV file... or Export > Custom Query
Result > CSV file... and the use these settings:
Fields terminated by: \t
Fields enclosed by: ""
Fields escaped by: \
Fields terminated by: \n
Select the option "Put field names at first row". Change the extension from
..csv to .xls.