when using the 'load data infile' commands how do i force the data
thats being loaded to completely be loaded
ie
LOAD DATA INFILE "data.txt" INTO TABLE datacontent.misc_code;
I have a file eg: data.txt thats 36 lines long, but is full of misc
text including some php + mysql code, so its not po
I think you would have to go a long way to beat DBTools which i might add
is free
and will convert most all db formats msaccess/foxpro/excell/dbf/csv/txt etc
etc to mysql
and also now supports PostgreSQL
http://www.dbtools.com.br
Steven
- Original Message -
From: "Michael Mauch" <[E
also http://www.dbtools.com.br this will work both ways access<>mysql also
supports excel , dbf, csv etc etc
Steven
- Original Message -
From: "Chris Grigor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 10:47 AM
Subject: [PHP-DB] Conversion from acces
you should maybe try the free dbtools mysql program from
http://www.dbtools.com.br
this can handle text file imports direct into a mysql db , also it can
import or export from excell , access, paradox, foxpro , dbase or odbc data
sources, very handy tool if all you ever use it for is the transfer