Forum Discussion
Power Query import from Access database is missing some columns
Hi, I am using Power Query to import data from an Access databse, however not all columns are being picked up. The main missing column I need is a Value List, so has no link/source in another ta...
I have the same problem! Quite a few columns from my Access table after I imported with Power Query were missing. I'm not sure whether it had a link/source in another table, on the other hand some columns that don't exist in the original table were imported. I would still like to solve thiis problem by using Power Query.
As an alternative what worked for me was to activate "legacy Acess data import wizard" to do that Select File > Options > Data.. activate it and then in Data use the legacy import wizard instead of Power Query.
As an alternative what worked for me was to activate "legacy Acess data import wizard" to do that Select File > Options > Data.. activate it and then in Data use the legacy import wizard instead of Power Query.
