Hi,
I have a contacts table where I also store the postal code and City in. Now, I wisely decided to split this information by adding a PostalcodeID field to the contacts table. I have also the table with the postal codes and Cities ready. I am looking for the wizard which I, once, when I imported some data from excel, automatically got. My question is, where this wizard can be found. Or if there is an other way to accomplish the operation of splitting the information.
I have a contacts table where I also store the postal code and City in. Now, I wisely decided to split this information by adding a PostalcodeID field to the contacts table. I have also the table with the postal codes and Cities ready. I am looking for the wizard which I, once, when I imported some data from excel, automatically got. My question is, where this wizard can be found. Or if there is an other way to accomplish the operation of splitting the information.