When the input is finished the phone numbers with the (555) 123-4567 doesn't input but the 5551234567 does and is formatted like the mask.
I'm using the following code to load the table.
Expand|Select|Wrap|Line Numbers
- Docmd.transfertext acimportDelim, , TempFile, Appath, true
I'm getting an ImportErrors file that says the phone number with the (555) 123-4567 Type Conversion Failure. Now I have a AltPhone in the same .csv file with the same two different phone formats and that loads just fine. I've checked the .csv file format and they are both the same. Also the database table that is loaded the two columns are the same. So why does one load and the other doesn't. I'm really confused.
Any help is appreciated.
Thanks