Export Data to Excel

[Anon]

how to export my data from mySQL PHP to excel. Because i tried it and its not working (sometimes excel treat comma in the database as "separate comma")

[[deleted]]

Use a different seperator, like
||;||
or something else that does not appear in the data.

[ogge1]

Vincent is on the right track there.

use ; instead. It's never associated to any values. Beware if you have freetext in the information. In that case you need to use quotes for the text. You also need a line separator.

I run into some pitfalls when making the CSV export function in AVirCAP/CodeREDHunter. I noticed that EXCEL handles linebreaks diffrent to ACCESS.

In excel it's sufficent to separate a line with \n but access demands \r\n

excel:
123;"joe";43\n
124;"fredrik";28\n

access:
123;"joe";43\r\n
124;"fredrik";28\r\n

Hope it helps!

/Fredrik