Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To merge (copy/paste) cells from two Access tables, all cells are Y or N.
I exported the two Access tables to Excel.
Table #1 is in text format
Table #2 is in number format

When exported to Excel Table #1 remains text - Y or N
But Table #2 changed to 1 or 2

Help-I need to change Tabel #2 to Text (Y/N) so I can merge (copy/paste) the
data into one...

Just changing the format of the cell in Excel does not change it to text.
 
How are you getting a Y or N into the second table in the first place? If it's a number format field, you shouldn't be able to put either of those values in there.

Anyways, your solution is probably to create a query for table #2 and substitute for the field in question the following:

iif ([Table#2]![Field] = 1, "Y", "N")
 
Back
Top