Forum Discussion
Import from Access to Excel returns empty table.
Hello. When linking an access query to excel using method Data>Get Data> From Database> From Microsoft Access Database, the table in Excel returns the column headers but no other data. When I got t...
_july_cesar are you using any wild cards (an * ) in your criteria? For example: like(*xyz)
If so, you will have to change them to the % as the wildcard designator. Excel doesn't like * as the wildcard designator. Once you change the wildcard designator to %, when you run the query in Access, it will come up blank; however, it will work when using Power Query into Excel.
Thanks! This worked for me as well! Not as easy to figure out yourself...