mdb o xls to SQL

[Percius]

I have a linux server with PHPmy admin installed, apache, php of course, and MYSQL. I need to get a database from cvs, xls, or mdb to the MYSQL server. Please can anyone tell me an easy way to do this.

I am root on the Linux server and have access so dosnt have to be a web based solution. Thanks.

PS. Tryed to find problem in pages before posted. If I missed it please tell me and I am sorry.

[Dvector]

You can insert data from a cvs using phpMyAdmin. There is a link at the bottom of any tables structure page.

To get data from excel, there is a plug-in you can download called "Microsoft AccessLink Plug-In" which will convert an excel spreadsheet to an Access database. Then to get data from the database, just export all the data you want as a Text (cvs) file.

phpMyAdmin just makes it easier to import the data, you could write the SQL statement by hand if you wanted:

LOAD DATA LOCAL INFILE 'your_local_cvs_file' INTO TABLE your_database FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY '\r\n'

Hope that helps

[Percius]

I cannot find the phpmyadmin option to load a CVS file, but I was able to run the command via the MYSQL console and enter the data so thank you.