Importing data with formatting mask

I have an Access 2007 database that manages typical personnel data, such as
name, address, several types of phone numbers, etc... All of the phone number
fields are formatted as text and an input mask is applied. When the mask was
created, I opted for the data to be stored with the symbols in the mask.

Running Visio 2007, I am trying to import personnel names and phone numbers
into shape data with the phone number input mask intact (i.e., paranthesis
and hyphen). When I perform the import, the phone numbers are just the
numbers, no input mask characters. Also, when I go into the database to
confirm the input mask is stored with the data field value, it shows it is
not.

What am I doing wrong? Is this type of import not possible?

You're not doing anything wrong. Local formatting instructions are not
transferred.

al

"sabow71" wrote:

I have an Access 2007 database that manages typical personnel data, such as
name, address, several types of phone numbers, etc... All of the phone number
fields are formatted as text and an input mask is applied. When the mask was
created, I opted for the data to be stored with the symbols in the mask.

Running Visio 2007, I am trying to import personnel names and phone numbers
into shape data with the phone number input mask intact (i.e., paranthesis
and hyphen). When I perform the import, the phone numbers are just the
numbers, no input mask characters. Also, when I go into the database to
confirm the input mask is stored with the data field value, it shows it is
not.

What am I doing wrong? Is this type of import not possible?

I need the phone number to look like a phone number when Visio receives it.
How do I include local formatting instructions when exporting to Visio org
chart?

"Al Edlund" wrote:


You're not doing anything wrong. Local formatting instructions are not
transferred.

al

"sabow71" wrote:

I have an Access 2007 database that manages typical personnel data, such as
name, address, several types of phone numbers, etc... All of the phone number
fields are formatted as text and an input mask is applied. When the mask was
created, I opted for the data to be stored with the symbols in the mask.

Running Visio 2007, I am trying to import personnel names and phone numbers
into shape data with the phone number input mask intact (i.e., paranthesis
and hyphen). When I perform the import, the phone numbers are just the
numbers, no input mask characters. Also, when I go into the database to
confirm the input mask is stored with the data field value, it shows it is
not.

What am I doing wrong? Is this type of import not possible?