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 table, but it's still not pulling through.
Any help would be greatly appreciated 🙂
- 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. I'm having the same problem. I have around 700 tables from Access (that are links to excel files) that I'm importing into excel. Now the first one that I pull in is only giving me the first column of the table. I go back and verify in Access and the original excel file that the other columns are there but still just get that first column in Power Query. The other 700 tables are in the same format and I haven't had the problem with them yet. So far I tried opening that problem excel file and copying the information onto a new sheet, deleting the original sheet and then renaming the remaining sheet to the original name. It doesn't look like that is working but I'm not sure as I'm using onedrive files and I haven't checked to verify that they are synced.
I used one of the other files that was working as a template, made a copy of it, copied the data from the problem file to the new copied template. Then deleted the problem file. Finally I renamed the newly created file and that seemed to solve the problem for me.
