> Does anyone know of a FREE utility that will export data from an MS
> Excel file and import it to MySQL. I have found a bunch of nice
> utilities, but none of them are FREE. I'm in a bind and have to get
> over 2000 rows imported to my database by morning and don't have to
> order one of the othe
Thanks Michael and Richard
I took your advice and wrote a PHP script to import it. I was having a
hard time getting Excel on my Mac to export to CSV and Tab Delim, but
finally got it to give me a plain text file which worked fine with
fopen().
Joe
On Friday, January 3, 2003, at 02:32 PM, Mi
I think BiffWriter might do it...
By why not simply output a comma delimited files from excel and import it in with a
small php script.
Mike
*** REPLY SEPARATOR ***
On 03/01/2003 at 2:20 PM Joe LoMoglio wrote:
>Does anyone know of a FREE utility that will export data from a
You could export, or save as a tab delimited text file, then go ahead and
use phpMyAdmin or a custom script to pull all that data into the database.
It really shouldn¹t be much of a problem coming from Excel.
Cheers!
Rick
"Finish each day and be done with it. You have done what you could; some
b
I use to save my access data to a dbf file and then use the dbf2mysql (see
www.mysql.com site).
dbf2mysql will create proper tables and export data to the mysql really
faster than odbc.
Very easy.
I have exported someting like 5.000.000 records into 8 differents tables in
4 hours (3 cdroms of acce
Guys getting more serious here now, 3 500 000 records, foxPro
i'll try Jeff's method
--
PHP General 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]
On Saturday 27 October 2001 17:11, Daniel Harik wrote:
> You see i have huge(for me) 100 000 record access table, i wanted to
> convert it to mysql, i thought of making php convertor that uses odbc
> and mysql, but maybe there is faster way?
Your subject says "excel" but above, you say "access".
I used Jeff's method
http://adsl20066.estpak.ee/emt here is it working live
Thank You Jeff so much
--
PHP General 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: [EMAI
Sent: Saturday, October 27, 2001 10:30 AM
>To: Daniel Harik; [EMAIL PROTECTED]
>Subject: Re: [PHP] Excel to MySQL
>
>
>At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>
>>You see i have huge(for me) 100 000 record access table, i wanted to
>>convert it to mysql, i tho
: Saturday, October 27, 2001 10:30 AM
To: Daniel Harik; [EMAIL PROTECTED]
Subject: Re: [PHP] Excel to MySQL
At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>You see i have huge(for me) 100 000 record access table, i wanted to
>convert it to mysql, i thought of making php convertor that uses odb
At 04:11 PM 10/27/01 -0800, Daniel Harik wrote:
>You see i have huge(for me) 100 000 record access table, i wanted to
>convert it to mysql, i thought of making php convertor that uses odbc
>and mysql, but maybe there is faster way?
Daniel,
You're making it too hard on yourself.
1. CREATE TABLES
11 matches
Mail list logo
