Hi all!
How do I import an Excel worksheet into Access when the Access tables have the State defined as Number. The State is a Foreign Key field in 2 Access tables. In Excel it is just the state abbreviations (TX, IA, OH, etc.) The State table is already set up and populated; it has 3 columns: State Key, State Abbr and State Name.
I would really prefer not to have to manually enter over 1,000 rows of data!
Thanks in advance!