Sure, it's possible by csv-export for example.
I have attached a file which needs to be changed for your usage.
This file was written to export all needed userdatas as CSV.
Enter YOUR DB-Datas:
define("select_table", "fusionj7i6e_users"); // Enter YOUR prefix and needed DB-table
define("csv_delimeter", ";");
define("db_user", "db_username"); // Enter YOUR DB Username
define("db_password", "db_password"); // Enter YOUR DB Password
define("db_server", "localhost");
define("db_db_name", "db_name"); // Enter the name of YOUR database
Change this line to your needs:
$sql = "SELECT user_fax, user_identnr, user_firma, user_vorname, user_nachname, user_strasse, user_plz, user_location "
."FROM " . select_table . " ORDER by user_fax ASC "
."LIMIT 65534 ";
That's all.
As a result you schould get a CSV-file which can be opened with MS Excel or OpenOffice Calc. |
