Export to database

Anon

Hi,
I want to ask how do we export the data from an .xls extension to the database..i.e. to MySQL..
The .xls document may contain First Name, Last Name & Email Addresses seperated by quamma(,)..

Naveen

crislewis

There are several ways to do this. A simple way would be to 'export' the data from excel to a formatted file (CSV, tab delimited).

Write a simple routine in PHP to open the file, read in each record (look at the verb 'explode', it can help parsing the data into an inumarated array based on the field delimiters) and insert it into the table.

Cheers,

Cris

[deleted]

Or read the MySQL manual about dbimport and 'LOAD DATA INFILE'.

crislewis

Good point, Vincent.

Naveen, look at section 3.3.3 of the latest manual (http://www.mysql.com/doc/L/o/Loading_tables.html if you don't have a local copy). It covers both methods. LOAD DATA does the second part of my suggestion without the programming.

Cheers,

Cris

Anon

How would you validate and import to PostgreSQL?

Anon

Thanks a lot for ur guidance guys.. It helped me a lot in solving some of my queries..
But how do I get the data from an xls file into the mysql database..

Naveen

crislewis

Between us we have answered this. Use the export function in xl to create a formatted file according to section 3.3.3 of the mysql manual and use LOAD DATA in mySQL.

Cris