[PHP-DB] Import Excel sheet into SQL
Hi, How can I import Excel sheet into MS-SQL. The data I have saved in excel sheet is in cells, snapshot is attached in this email. I am using sqlmyAdmin. and tried using import but getting error Invalid Count on line1 Help required!!! Nasreen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Import Excel sheet into SQL
Save your excel file as CSV, and run the following command: mysqlimport --fields-optionally-enclosed-by= --fields-terminated-by=, --lines-terminated-by=\r\n --user=YOUR_USERNAME --password YOUR_DATABASE YOUR_TABLE.csv Make sure not to include the headers of your excel columns and to set up your table beforehand. Don't forget to replace all necessary parts in the command above. If you're not on Windows you should probably use \n instead of \r\n for the newline character. On Fri, Sep 5, 2008 at 1:12 PM, Nasreen Laghari [EMAIL PROTECTED] wrote: Hi Evert, I have attached it again. Regards, Nasreen - Original Message From: Evert Lammerts [EMAIL PROTECTED] To: Nasreen Laghari [EMAIL PROTECTED] Sent: Friday, September 5, 2008 11:03:18 AM Subject: Re: [PHP-DB] Import Excel sheet into SQL Attachment didn't make it On Fri, Sep 5, 2008 at 12:00 PM, Nasreen Laghari [EMAIL PROTECTED] wrote: Hi, How can I import Excel sheet into MS-SQL. The data I have saved in excel sheet is in cells, snapshot is attached in this email. I am using sqlmyAdmin. and tried using import but getting error Invalid Count on line1 Help required!!! Nasreen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Import into mysql from csv-file
Hi, how do I import data stored in a csv-file (formated text) into a mysql_database. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [Import text file]
A quick trip through the MySQL manual hints that you may have to use forward slashes in your path on a windows system. So... LOAD DATA LOCAL INFILE 'C:/WINDOWS/TEMP/phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) ...might just do the trick (note the forward slashes in the path to the file). Hope this helps. -Original Message- From: RG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [Import text file] Hi I try to do an import text file into a mysql table with the php script provided with Manucorp Easyphp, but it does not work. The message is : Erreur requete SQL: LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) MySQL a repondu:File 'c:windowstempphpc255.tmp' not found (Errcode:2) The path above seems to be incorrect, but i have not found where to modify it. Environment is : Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
FW: [PHP-DB] [Import text file]
Just forwarding this on to the general list as it was only sent directly to me. -Original Message- From: karthikeyan.balasubramanian [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 9:03 AM To: Hutchins, Richard Subject: Re: [PHP-DB] [Import text file] try using something like this C:\\WINDOWS\\TEMP\\PHPC255.TMP Hope this works. Have a great day. - Original Message - From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 6:41 PM Subject: RE: [PHP-DB] [Import text file] A quick trip through the MySQL manual hints that you may have to use forward slashes in your path on a windows system. So... LOAD DATA LOCAL INFILE 'C:/WINDOWS/TEMP/phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) ...might just do the trick (note the forward slashes in the path to the file). Hope this helps. -Original Message- From: RG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [Import text file] Hi I try to do an import text file into a mysql table with the php script provided with Manucorp Easyphp, but it does not work. The message is : Erreur requete SQL: LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) MySQL a repondu:File 'c:windowstempphpc255.tmp' not found (Errcode:2) The path above seems to be incorrect, but i have not found where to modify it. Environment is : Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Import text file]
This LIST need some change :). Generally we just say reply and give our suggestions. This works in other list. This one goes only to the person who posed the question. Have a great day. Karthikeyan B. - Original Message - From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 7:59 PM Subject: FW: [PHP-DB] [Import text file] Just forwarding this on to the general list as it was only sent directly to me. -Original Message- From: karthikeyan.balasubramanian [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 9:03 AM To: Hutchins, Richard Subject: Re: [PHP-DB] [Import text file] try using something like this C:\\WINDOWS\\TEMP\\PHPC255.TMP Hope this works. Have a great day. - Original Message - From: Hutchins, Richard [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 6:41 PM Subject: RE: [PHP-DB] [Import text file] A quick trip through the MySQL manual hints that you may have to use forward slashes in your path on a windows system. So... LOAD DATA LOCAL INFILE 'C:/WINDOWS/TEMP/phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) ...might just do the trick (note the forward slashes in the path to the file). Hope this helps. -Original Message- From: RG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 6:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] [Import text file] Hi I try to do an import text file into a mysql table with the php script provided with Manucorp Easyphp, but it does not work. The message is : Erreur requete SQL: LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) MySQL a repondu:File 'c:windowstempphpc255.tmp' not found (Errcode:2) The path above seems to be incorrect, but i have not found where to modify it. Environment is : Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] [Import text file]
On Friday 14 February 2003 00:29, karthikeyan.balasubramanian wrote: This LIST need some change :). Your email client needs changing :) Generally we just say reply and give our suggestions. This works in other list. The 'other' list is broken. This one goes only to the person who posed the question. Real email clients gives you multiple response methods -- reply to sender; reply to list; reply to all; bounce; redirect etc -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Drinking is not a spectator sport. -- Jim Brosnan */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [Import text file]
Hi I try to do an import text file into a mysql table with the php script provided with Manucorp Easyphp, but it does not work. The message is : Erreur requête SQL: LOAD DATA LOCAL INFILE 'C:\WINDOWS\TEMP\phpC255.TMP' INTO TABLE abonnes FIELDS TERMINATED BY ';' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' (dp_indpri,dp_nom,dp_ville) MySQL a répondu:File 'c:windowstempphpc255.tmp' not found (Errcode:2) The path above seems to be incorrect, but i have not found where to modify it. Environment is : Apache 1.3.17 win32 PHP 4.0.5-dev MySQL client API version 3.23.32 An idea ?? RG [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Import and export data from php/mysql
I would like to know, if there is any change to export/import data from MySQL/EXCEL/MySQL with php??? It's very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Import and export data from php/mysql
What is your problem exactly? Have you investigated the MySQL manual under: LOAD DATA INFILE SELECT ... INTO OUTFILE ? Ignatius - Original Message - From: Bruno Pereira [EMAIL PROTECTED] To: PHP-db list [EMAIL PROTECTED] Sent: Friday, January 24, 2003 1:51 PM Subject: [PHP-DB] Import and export data from php/mysql I would like to know, if there is any change to export/import data from MySQL/EXCEL/MySQL with php??? It's very important. So if someone knows a way please help me. Thanks. Cumprimentos Bruno Pereira [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Import/Export data
Hi, How can I import/Export data to MySQL database using PHP following formats: EDI, Access, Excel ? Where can I find information about this ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Import/Export data
Hi The most universal way would be to export the table to CSV format. You can then use LOAD DATA INFILE phpMyAdmin to load it into the database. http://www.mysql.com/doc/L/O/LOAD_DATA.html HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: Rosen Marinov [mailto:[EMAIL PROTECTED]] Sent: 18 April 2002 17:28 To: [EMAIL PROTECTED] Subject: [PHP-DB] Import/Export data Hi, How can I import/Export data to MySQL database using PHP following formats: EDI, Access, Excel ? Where can I find information about this ? Thanks, Rosen Marinov -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] import error into mySQL
Howdy, New to databases, mySQL, and PHP. In my first PHP/mySQL application I'm loading data from a flat file exported from a Paradox database. Dates in one field import as -00-00 though they import properly in other fields. They appear to be configured alike - dob DATE date_reg DATE - and the data in the text file is correct. Loaded data from local infile declaring delimiter as ',' and field enclosure as '' (double quote). Also have run some select queries where field_name is null that do not return any rows yet visual examination of fields after select * query shows no data. Thoughts? Dave Pollak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] import error into mySQL
Show your code and table set-up. That would help. -Original Message- From: Dave Pollak [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 1:37 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] import error into mySQL Howdy, New to databases, mySQL, and PHP. In my first PHP/mySQL application I'm loading data from a flat file exported from a Paradox database. Dates in one field import as -00-00 though they import properly in other fields. They appear to be configured alike - dob DATE date_reg DATE - and the data in the text file is correct. Loaded data from local infile declaring delimiter as ',' and field enclosure as '' (double quote). Also have run some select queries where field_name is null that do not return any rows yet visual examination of fields after select * query shows no data. Thoughts? Dave Pollak -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] IMPORT DATA
hello all, did anyone know on how to import data from one database to another using Mysql? Thanks
Re: [PHP-DB] Import
if you are using phpmyadmin just click your database (its listed at the left column) then at the right side select "structure and data" which is located under "View dump(schema) of database" part, then select send and then click "go" you ll be asked for the path of your backup sql file. thats it. :) ""Pankaj Ahuja"" [EMAIL PROTECTED] wrote in message 012c01c0a7a0$9c3922d0$0101a8c0@server">news:012c01c0a7a0$9c3922d0$0101a8c0@server... I wonder if I am posting this to the right group but can anyone tell me how to import all the tables (including the information)from the server to my local machine and vice versa. I am using a mysql database. Many Thanks Pankaj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Import
i think there is a command something like mysqldump try checking the mysql docs At 01:06 PM 3/8/01 +0530, Pankaj Ahuja wrote: Thanks, but is there any other method. Say something at telnet prompt. I do not use phpmyadmin - Original Message - From: Emre YILMAZ To: [EMAIL PROTECTED] Sent: Thursday, March 08, 2001 1:01 PM Subject: Re: [PHP-DB] Import if you are using phpmyadmin just click your database (its listed at the left column) then at the right side select "structure and data" which is located under "View dump(schema) of database" part, then select send and then click "go" you ll be asked for the path of your backup sql file. thats it. :) ""Pankaj Ahuja"" [EMAIL PROTECTED] wrote in message 012c01c0a7a0$9c3922d0$0101a8c0@server">news:012c01c0a7a0$9c3922d0$0101a8c0@server... I wonder if I am posting this to the right group but can anyone tell me how to import all the tables (including the information)from the server to my local machine and vice versa. I am using a mysql database. Many Thanks Pankaj -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Import database in access to mysql
Yes u can... by using MyODBC from www.mysql.com Make ODBC connection to your database (via 32bit ODBC in control panel) and than you can export tables directly to MySQL database as loading data from MySQL. I forget web page where this was shown step by step, sorry... Vojtech - Original Message - From: Jennifer Demeterio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 10:17 AM Subject: [PHP-DB] Import database in access to mysql hello, i'm using mysql as my database with php but i have an existing database in access, is it possible to import the database in access to mysql ? thanks in advance... hunny -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
