Don't use the text function here.... this should work:
[GAME] & ' ' & [GAME DATE] as [GAME AND DATE] or
[GAME] & ' ' & Date([GAME DATE]) as [GAME AND DATE]
Once you concatenate a non text field with a text field, it automatically converts into a text field.
EDIT: First one seemed to work:
GAME & ' ' & [GAME DATE] as [GAME AND DATE];
LOAD * Inline [
GAME, GAME DATE