go download dbtools from dbtools.com.br importing is a snap with it. Its the only thing I use now. I tried all of them including mysql-front and I'm still with dbtools. Its freeware. You won't even have to export a comma delmited file, dbtools will go directly from access to mysql.
----- Original Message ----- From: "FlashGuy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 1:20 PM Subject: OT: CF and mySQL - cont'd thread > I don't know what I'm doing wrong. I've check the DOC but I can't seem to import a comma-delimited text file exported from Access into mySQL. > > I've created the database, table and fields. WHen I do a Import texfile everything looks OK via MySQL-Front. My text file contains only commas as delimiters separating each > field. > > MySQl fields and settings: > > ID (Type: TinyINT(3), Primary Key, autoincrement) > var (longtext) > destination (longtext) > > Access fields: > > ID (generated automatically by Access) > var > destination > > When I import the text file anf go into data I should have 841 entries but I only see 127? I see no text in the fields other than (Memo). > > What am I doing wrong? > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
