If y0ou want to do this the easy way, check out the products from Intelligent Converters <http://www.convert-in.com/>. They aren't free, but they deliver a lot of value.
Their basic Access-to-MySQL version is $39.85. "Pro" is another $15 and they have bundles with their other products. Cary At 01:20 PM 10/30/2002 -0500, you wrote: >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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
