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=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
