merge from phone numbers from Excel with rules

G

Guest

Thanks for the help. We have an Excel spreadsheet that holds phone numbers.
We would like for all phone numbers to merge into Access in this format (555)
555-5555. Is there a way to control this so Excel can only hold this format
or that Access can only import with this format?

I already use the input mask but it doesn't take care of things like a
skipped area code.
 
R

Rick B

How would you like it to handle a skipped area code? How would the user
handles this when entering a number? Would it be allowed, or it would it
tell the user that the number did not fit in the format?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use an update query for Phone Number fields 2
Formatting issue with imported telephone number! 2
Formatting phone numbers 5
input mask issue 5
updating a table 2
how to change format of data already entered 5
Microsoft Active Voice Phone Dialer 1.5 won't follow dialing rules 1
phone number formatting 2

Top