Import from a csv leaves blank cells

[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?????? The column is set to text!

Thanks in advance
Glen

 

[Blorf]

There is a comma between fields I assume. Is there any chance that your import spec is using either a space or comma as a delimiter?

Further, can you have the source put quotes around your text fields, that usually fixes things.

ChaZ

 

[GlenLynam]

It is a CSV file so there are commas as delimiters its when there is a space between the numbers that it ignores that cell. I cant add quotes as this is the output file for the logging sytem for my phone switch, therefore it is pretty standard.
Any other ideas??????

Thanks
Glen

 

[Blorf]

Only other idea I have then is to read the file with out dilimiters, and parse your records one line at a time. Good news is you have commas to seperate, so this should not be too difficult, but requires vba coding.

Would be happy to help, unless anybody else sees another solution.

ChaZ

 

[GlenLynam]

All,

Thanks for the input this is actualt the route i have taken using docmd commands from within VB, still didnt work, i have had to set up a import template within access and when i cal the info into outlook i call that template and it all comes in fine!!

Thanks

Again

Glen