Re: [PHP-DB] Import Excel sheet into SQL

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 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

Re: [PHP-DB] [Import text file]

MAIL 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. > - Or

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) .

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, J

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 softwar

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 ap

Re: [PHP-DB] IMPORT DATA

>did anyone know on how to import data from one database to another using >Mysql? Yes. Take a look at the mysql website (www.mysql.com) you could also browse the archive of their list. This is a FAQ on the mysql.com list, so the answer can be found there. Bye, B. -- PHP Database Mailing

Re: [PHP-DB] IMPORT DATA

Hi Jennifer, Please clarify. What exactly do you want to do? MySQL has other utilities like mysqldump (to dump a db to a dbfile) and mysql (to restore a dbfile into a database). Lester At 03:13 PM 5/2/01 +0800, Jennifer Arcino Demeterio wrote: >hello all, > >did anyone know on how to impo

Re: [PHP-DB] Import

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 phpmyadm

Re: [PHP-DB] Import

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 phpmyadm

Re: [PHP-DB] Import

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 phpmyadm

Re: [PHP-DB] Import

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 "

Re: [PHP-DB] Import

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

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.

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 Messag