Exporting data to tab-delimeted files

[coned]

When I export data from a MS access table to a tab delimeted file the resultant file will randomly skip some of the tabs in a record and begin a new record in what appears to be part of the particular filed from the previous record. This doesn't happen every time and doesn't seem to relate to anything in particular -- except, I think that when a blank or null value is present in a field it's causing this problem. Can anyone help? What should I do?
thanks

 

[NorthNone]

Instead of exporting the table itself, create a query. In the query replace the nulls with "" or " " or 0 or the like in all fields where nulls are a problem. Then when you create up the tab-delimited file all the fields will have been trapped for nulls and all fields will be accounted for.

"Character cannot be developed in ease and quiet. Only through experience of trial and suffering can the soul be strengthened, ambition inspired, and success achieved." - Helen Keller