J
jonmarcr
This is something I can do with Excel but if results in a 33MB file and the
link tables are just a little slow. I've battled with it for two solid days
and have got nowhere (well I've got to the point where I have half a result
with loads of #Error cells
I import (among other stuff) address fields Add1 Add2 Add3 Add4 Add5 Postcode
Our database expects the City and the County to be in slots Add4 and Add5.
The external database simply fills up fields starting from the left so a
2-line address will have the City in Add2 and a three line address will have
the City in Add2 and the County in Add3 and so on. My task is to use logic
to get (90-95%) the addresses into the correct fields. I can manage it in
Excel using nested If statements and that is how I have been trying to do it
in Access but I can only get so far - not too bad but the tests that throw up
an empty cell return #Error and that I cannot get rid of.
The second tidy-up is a series of telephone numbers which we want to display
nnn-nnnn-nnnn but the database imports them as nn n - nnnnnnnn or as nnn
nnnn-nnnn or almost any other messy combination. Again in excel this is easy
but I am tearing my hair out in Access
Any ideas please?
link tables are just a little slow. I've battled with it for two solid days
and have got nowhere (well I've got to the point where I have half a result
with loads of #Error cells
I import (among other stuff) address fields Add1 Add2 Add3 Add4 Add5 Postcode
Our database expects the City and the County to be in slots Add4 and Add5.
The external database simply fills up fields starting from the left so a
2-line address will have the City in Add2 and a three line address will have
the City in Add2 and the County in Add3 and so on. My task is to use logic
to get (90-95%) the addresses into the correct fields. I can manage it in
Excel using nested If statements and that is how I have been trying to do it
in Access but I can only get so far - not too bad but the tests that throw up
an empty cell return #Error and that I cannot get rid of.
The second tidy-up is a series of telephone numbers which we want to display
nnn-nnnn-nnnn but the database imports them as nn n - nnnnnnnn or as nnn
nnnn-nnnn or almost any other messy combination. Again in excel this is easy
but I am tearing my hair out in Access
Any ideas please?