S
Support
Hi, I have been given some call data from my telecomms provider in csv
format.
I have tried importing that into excel so I can then import into an access
table but the format got emssed up so I have converted the raw data file to
txt.
Problem I have is that if I then import this into excel, I have leading
zeros in my CalledNo field and cannot run my queries.
I have tried importing directly into access but I still have the problems of
leading zeros.
Is there an access function that will remove these or is it more an excel
problem?
Or can I just add the leading zero into my query? I have tried using
running my standard query but it pops up asking for a prameter value.
Thanks
format.
I have tried importing that into excel so I can then import into an access
table but the format got emssed up so I have converted the raw data file to
txt.
Problem I have is that if I then import this into excel, I have leading
zeros in my CalledNo field and cannot run my queries.
I have tried importing directly into access but I still have the problems of
leading zeros.
Is there an access function that will remove these or is it more an excel
problem?
Or can I just add the leading zero into my query? I have tried using
running my standard query but it pops up asking for a prameter value.
Thanks