Forum Discussion
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, salary) based on last name. When doing a simple wizard query (Access: Lastname, Firstname, Hiredate, Jobtitle / Excel: Totalbenefits) the query returns the correct headers but otherwise remains blank. In the design view it shows the correct tables and view as checked.
I'm a new user to Access (this is a class lab assignment). I followed the instructional video to a T, but when the professor runs the query the results populated without a hitch.
- Look again? The VALUES for FirstName in one of them are in the LastName field in the other, and vice versa.
- In order to help us help you, please provide more specifics in addition to the general description.
We need to see the SQL in the attempted query, preferably from the SQL view.
Also, data. Show us the data. Screen shots of the two tables should work.I'm happy to try and provide anything, not sure what the SQL is- If you can give me an idea of what to look for I'll do my best to find it. (Prior to this class, I've never used access- so thank you for your patience).
The names, addresses, etc are all made up for the assignment.
- Maybe my eyes are failing, but it sure looks to me like the First and Last Names are swapped in those tables in your screenshot
- 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.- I imported using the External Data Tab> New Data Source > From File > Excel
