import of phone numbers

[Guest]

I have a text file with telephone numbers. The numbers are formated with the
int. countrycodes. Example +31-10-1234567
When I ty to import this into an Access table with the Import Text Wizard
the +31- part of the phonenumber is not visible and it is not imported.....
How can I solve this?? I use Access 2003.
Thanks,
Rob

 

[Guest]

It's the plus sign messing things up. I tried going into Advanced in the
import wizard, but nothing there helped. Even tried importing it as a Memo
field and linking to the file. No joy. If you strip out the + the rest
imports properly so that is one option.

Roger Carlson has a sample database that uses LineInput to import text files
instead of the normal import tools. Look for the ImportLineInput.mdb file at:

http://www.rogersaccesslibrary.com/TableOfContents3.asp

 

[John Nurick]

There does seem to be something rather strange happening. If all the
phone numbers are in canonical format, e.g.
+44 (1232) 567890
+1 (345) 555-5678
+33 (8) 12 34 56 78
+61 (2) 2345 6789
they seem to import OK, but numbers formatted like Rob's
+31-10-1234567
not only lose their own +31 but also upset canonically formatted numbers
in the same file. I'm reporting it as a bug.

 

[Guest]

Hi,

I used the "import by code" methode, and that is working.
Thanks for your help.
Rob