When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ?

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Community >> Computer Software and Hardware issues >> When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ?

Page: [1]


lsfphelpls Posts: 443 Joined: 3/16/2005 Status: offline	When I EXPORT an xls file to csv or other delimiter fil... - 12/1/2007 16:05:08 EXCEL: When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ? how i configure EXCEL to export as FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';' FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY ''' LINES TERMINATED BY '\n' When I save as xxx.csv I have any choice over: FIELDS SEPARATED BY ',' -or- FIELDS SEPARATED BY ';' FIELDS ENCLOSED BY '"' -or- FIELDS ENCLOSED BY ''' LINES TERMINATED BY '\n'


jaybee Posts: 13972 Joined: 10/7/2003 From: Berkshire, UK Status: offline	RE: When I EXPORT an xls file to csv or other delimiter... - 12/1/2007 16:15:35 You have now posted this question several times and not just on here but all over the web. I have answered you and referred you to several sites. You either aren't reading them or are not understanding them. This is a phpMyAdmin issue, not an Excel issue. Excel produces what it produces and that's it. If you had done a google search as I suggested in another reply you would have found a number of answers. Here is yet another and it's my final word on the subject. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to lsfphelpls)


lsfphelpls Posts: 443 Joined: 3/16/2005 Status: offline	How I add apostrofes() manually or automatically to the... - 12/2/2007 4:58:10 Please answer and this last thing: How I add apostrofes(') manually or automatically to the START/END of cells contains (in an excel file) ? (in reply to jaybee)


jaybee Posts: 13972 Joined: 10/7/2003 From: Berkshire, UK Status: offline	RE: How I add apostrofes() manually or automatically to... - 12/2/2007 8:13:12 Have you visited and read the link I gave you above? It tells you what to do when you are asked for Enclosures. You shouldn't need the ' at the start and end. If you do then you have to type it into the field yourself and that probably means formatting the fields to text. It can also be done by writing a Macro but don't even ask about that one. If you want to learn about Macros then book on a training course. _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to lsfphelpls)


lsfphelpls Posts: 443 Joined: 3/16/2005 Status: offline	I make it at last , how I make a copy of an existing ta... - 12/2/2007 12:12:59 I make it at last , how I make a copy of an existing table in phpMyAdmin or SQL ? (in reply to jaybee)


jaybee Posts: 13972 Joined: 10/7/2003 From: Berkshire, UK Status: offline	RE: I make it at last , how I make a copy of an existin... - 12/2/2007 12:51:05 Google Results - click here _____________________________ If it ain't broke..... fix it until it is. GAWDS Now where did I put that Doctype? (in reply to lsfphelpls)

Page: [1]

All Forums >> Community >> Computer Software and Hardware issues >> When I EXPORT an xls file to csv or other delimiter file , by how many ways I can do it ?

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts