Re: !!! Help !!! Can't dbimport badabase

Fred, The most probable reason why this is doing is because there is a "|" in the database. When you exported the database, it had a "|" in the UNL file which is difficult is the default delimiter. When this "|" was unloaded it is unloaded as "/|" due to this it is unable to identify "/" as a character and it is tring to change as a numberic value. Also, See in the export file if there were any errors. -Rohit fprose@hotmail.com (Fred Prose) wrote in message news:<195a4770.0312020629.777d56a@posting.google.com>... > First question: Did anything import, or did it fail on the first > table? > > I think I'd start looking at the delimiters in the .unl file. There > might be a "|" as part of the actual text, which could through off the > delimit and cause dbimport to think it's importing a number when it's > actually tricked into looking at text. > > One place to start would be the table that the import fails on. > > Work around. > > 1. Create the structure using the xxxx.sql file created by the > dbexport. > 2. While this might be time-consumming, manually use dbaccess and > "load from..." to import the tables. > 3. With the failing table you may need to edit the .UNL file and > remove the false delimiters.