Import from csv doesnt import certain records

[GlenLynam]

Morning,
When i import from a csv file in access there is a phone number field. These numbers are all in different formats hs is where my problem arrises. Whenever there is a space or a dash in he number ie 01234 123456 or 01234-133456. it doesnt import the fields but still imports the rest of the rcord. This is done via and automatically run program that i have written but it does it even if i manualy import through access....any ideas??????

Thanks in advance
Glen

 

[PHV]

even if i manualy import through access
even if you define the field as Text ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[GlenLynam]

Yes the field is already defined as text there is something it doesnt like about the spaces and dashes that are in some of he records??