Well, I guess that you are doing the exporting manually and not through
VBA, right?
Then select your entire table 2.
Clcik on 'Edit' Menu and Select 'Replace'
In Find What: enter 1
In Replace With: Y
Click on Options and check 'Match entire cell contents'.
Click on Replace All.
Repeat for 2 to be replace by N
Sharad
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!