On Wednesday 17 October 2007 07:29:31 Andrew Jensen wrote: Hi Drew,
> Darn MSAccess export files with booleans ( 0,1) and text fields can > looks like: > > 2145,0,0,0,1,"Some text, and more text / all one field",0,0,2.15 > > That damned embedded comma..you know. Even better, this is a valid > export from MSA also: > > 2145,0,0,0,1,"Some text, and I"ll make more text / all one field",0,0,2.15 > > A typo during data entry no doubt, but MSA takes it and exports it just > like that...arrrgh > If its any consolation at all, FileMaker Pro allows the same behaviour, the same also occurs with line breaks, and date fields are even worse :-(( as I have found out to my cost when migrating. At present, I have found no way to get around this problem when trying to open CSV files into Calc and then import them into Base. Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]