Data Sorting

[Lindsay]

I am creating a database to create purchase orders. I have a large
excel spreadsheet with all the employee information that needs to go
into the database. This spreadsheet needs to be updated every quarter.
There are a few problems though. In the excel spreadsheet the phone
and fax numbers are in the same column, which means there are duplicate
records of employees accounting for the phone and the fax number.
There is another column next to the phone/fax column that indicates
whether it is a phone number or a fax number. I need to create some
sort of expression to put in a macro, so a user that is not myself can
quickly and efficiently upload the employee data to the system. Could
someone offer any suggestions?

 

[OfficeDev18 via AccessMonster.com]

You already know that the data in the spreadsheet is not normalized. If you
cannot normalize it by putting the fax number in a separate column, I would
suggest simply losing the fax column for purposes of the purchase order table,
and only importing/linking based on the value of the phone/fax flag = phone.
Alternatively, you can import the entire spreadsheet as is, and once in
Access you can play with the data, and put the data into a new table before
using for any purpose.

Hope this was helpful.

Sam