Welcome Guest, Not a member yet? Register   Sign In
Export database data into different columns of a csv file
#4

[eluser]Hampti[/eluser]
Hi there,

1) use
Code:
$enclosure = '"';
  $delimiter = ";";

2) set MS Excel CSV-Import Options accordingly

3) use openOffice or libreOffice

If i am right the latter ones let you choose delimiter, enclosure and character set on csv import. In Microsoft Excel it has to be set somewhere in options i believe, you wont get asked on importing the file.

Best Regards,
Constantin



Messages In This Thread
Export database data into different columns of a csv file - by El Forum - 08-03-2012, 06:59 AM



Theme © iAndrew 2016 - Forum software by © MyBB