Andrew Gaffney <[EMAIL PROTECTED]> wrote: : : Some of the cells in the table have newlines in them. : Because of this, when it's exported from Excel, the : 2nd line will appear in the correct field, but on a : line by itself: : [snip] : : So it looks like 3 records instead of 2. Does anyone : have any ideas on how to pick apart the data to get : it into the DB?
How about replacing the newlines in a copy of the Word file. Swap them for something that is not in the table, like "~~~". Then add them back as you read the records into your database. HTH, Charles K. Clarkson -- Mobile Homes Specialist 254 968-8328 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>