Importing text - "+"(plus) is getting purged...suggestions?

[Taran72]

Hello...

My job requires importing tab and comma delimited text files into Microsoft Access. Often, some of the fields contain overseas phone numbers. Here's an example:

+45-22-917-1234

Access seems to be purging out the "+45-"; this is what gets imported:

22-917-1234

This does not happen if I import the same data from an Excel file. However, that is not useful. I realize Access is probably picking that up as a function or formula, but I do not know how to tell Access otherwise. Any suggestions? Thank you.

 

[lameid]

Are you appending this data to an existing table?

If so, the field must be big enough, have the datatype text, and not have a validation rule on the field preventing the proper import.

 

[Taran72]

Yes, I am importing this data into an existing empty table with headers in place. The field has a 255 limit and has the datatype text. As for a validation rule, I am not so sure...but I do not think so.