In Access I have a table field with a 4-digit policy number. I created a query to provide all policies beginning with an A. That is, Criteria is Like "A*"
In Access, I get all the A results.
Next, I open Excel 2010 and use "Insert Pivot Table" but no A policy numbers are imported. (If I delete the Like "A*", the refresh gives me all policy numbers, so the import works.
It appears that 2010 has an issue with Excel not recognizing the wildcard from Access. Any ideas? Thanks,