Forum Discussion
Power Query import from Access database is missing some columns
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.