I have an MsAccess File which has tables in it in which i have number of columns in each table but what i want is I have an 2 columns in it name it as refrence and refrence1 which contain data like 1234-1-ABC-123 in both refrence and refrence1 columns what i want to do is
1st Thing is to merge all the refrence1 data to refrence
2nd Thing is i want this data to be divided in to 4 parts as 1234 1 ABC and 123 as four columns saperatly
So this is my problem i am not getting any idea how to do it is their any way to do this task let me know...
Data Currently is like this 1234-1-ABC-123 in Single column
Result i want is 1234 1 ABC and 123 in four columns