Just did this to a 65mb fixed width file.
What I did was get it into a csv file via perl :)
Then I created the db table.
Then I used:
load data infile "/file.csv" into table blah fields terminated by ',' ;
then go ahead and create any indexes etc...
!works slick!
> Is there an easy way to do this? I know that SQL Server can export a comma
> delimited file, can mySQL import this? I imagine the PHP will be easy to
> modify as long as the field names are the same.
--
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]
