Afan Pasalic wrote:
?php
#names of columns in products table
$column_names = array('ITEM NUMBER', 'ITEM NAME', 'DESCRIPTION',
'COLORS', 'INCLUDES', 'QTY', 'PRICE', 'IMAGE', 'THUMB', 'CATALOG',
'STATUS', 'SUPPLIER', 'EXP_DATE');
if(isset($_POST['SubmitExcelFile']))
{
#VALIDATING
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
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
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,
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 other
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
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
: 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 odbc
and mysql
; [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 odbc
and mysql, but maybe there is faster way?
Daniel
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:
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. If,
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]
12 matches
Mail list logo