Is there any way to prevent the lost in phone format (000)000-0000 and fax
format (000)000-0000 when transferring data using DTS between tables? The
data we have is inconsistent, so we really don't want to lose the formats if
possible.

SQL Server and DTS do nothing themselves related to formatting data. As long
as your values are defined as a string with the parens and dash embedded
within the text, as opposed to being applied externally via a mask in the
user interface, you shouldn't have any problem. When you view the data in
Access, are you sure there isn't some type of mask being applied? It sounds
like there might be....

--
--Brian
(Please reply to the newsgroups only.)


"Mike Moore" <MikeMoore (AT) discussions (DOT) microsoft.com> wrote