Import/Export

[Simon]

I am trying to design an import/export utility but
keep coming up against the problem of row and column delimiters.
Our data has every possible combination of delimiters in the data itself
so of course this causes the import to fail.

Basically I need a way to export and import a given table to a text file.
Is there any way to solve this without continually worrying about delimiters.

[Simon]

Thanks Duncan,

I will still need to program DTS this to deal with multiple tables
but your suggestion has given me a way forward.


------------
duncan maddox at 12/4/00 6:19:44 AM


Why not used a fixed field length format ? No delimiters are required.

DTS offers this format and this should get around your problem.

duncan

------------
Simon at 12/3/00 9:57:36 PM

I am trying to design an import/export utility but
keep coming up against the problem of row and column delimiters.
Our data has every possible combination of delimiters in the data itself
so of course this causes the import to fail.

Basically I need a way to export and import a given table to a text file.
Is there any way to solve this without continually worrying about delimiters.