Forum Discussion

GennyK's avatar
GennyK
Copper Contributor
Mar 10, 2023
Solved

Access and Excel wizard query blank beside headers

I imported an excel datasheet (Lastname, firstname, Healthins, Retirement, TotalBenefits) into Access and created a relationship with an Access database (Lastname, Firstname, Hiredate, job title, sal...
2016
access
office 365
  • George_Hepworth's avatar
    George_Hepworth
    Mar 11, 2023
    Look again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.
arnel_gp's avatar
arnel_gp
Iron Contributor
Mar 11, 2023
How did you Import your datasheet?
If you use Copy/Paste, chances are there are "hidden" (non pritable) characters (mostly at the end) of your imported data.
  • GennyK's avatar
    GennyK
    Copper Contributor
    Mar 11, 2023
    I imported using the External Data Tab> New Data Source > From File > Excel

Resources