I export data from Quickbooks to excel, then import into access. Having
had problems with duplicate social security numbers and access was not
catching it.
The data in Quickbooks shows a social security number as 000-00-0000,
but it is not required to put the dashes and it has happend that an
employee is listed twice in access, once with and once without the
dashes.
To avoid this, I am trying to eliminate the dashes in excel before
importing into access.
We the data is exported from Quickbooks, I have tried to format the
social security column as text, as well as general, but when I use Find
and Replace to get rid of the dashes, it loosing the zeros of the first
character.
Any suggestions?
Anne
--
annep
------------------------------------------------------------------------
annep's Profile:
http://www.excelforum.com/member.php...o&userid=18851
View this thread:
http://www.excelforum.com/showthread...hreadid=568622