I've been having a tough time importing comma-delimited files into my database tables. I just discovered that most of the errors are similar to this one:
"060 " is not a valid integer value I checked my spreadsheet - Microsoft Works - and discovered that there's a space after many of my numerals. I'm not sure how to remove these spaces. I didn't see anything in the Help files. I could do a search and replace, but that would also wipe out spaces between words - like... Tripp<space>County I just wondered if there's a simple trick anyone knows of for getting rid of spaces like these or preventing them in the first place. Thanks. __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]