-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Power Qry Problem
- Thread starter jtodd
- Start date
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,342
- Office Version
- 365
- Platform
- Windows
Are your data types the same in both tables for the primary key(s)? Are there leading or trailing spaces or non-printing characters in one the primary key(s)? These would be factors that I would investigate first.
Upvote
0
RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,232
- Office Version
- 365
- Platform
- Windows
- MacOS
A gentle reminder:
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at:
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at:
Error when combining multiple excel file using Query
Hi, i am trying to combine multiple Excel file from raw data. However, I get error on the very first step. My file is consistent layout, with Row 1 to Row 6 being the Company name and the Respective GL name which i wanted to remove. Row 8 is also to be deleted. Leaving only Row 7 as...
www.excelforum.com
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Upvote
0
Similar threads
- Solved
