Load Data from Excel Power Query to Access table

Question

I have an excel file that collects data from multiple txt files into connected individual tables (1 table per each file) as connection only tables. I have done this because some of them contain >1m tables. In excel, I have appended those tables using Power Query/Apend function. I need to create a new table that contains all the data, however the resulting data is >1m rows, and I can't load it back to excel.

Is there a way to load my connection (summary of all tables) to access?

When I try to do that using import function in access, it does not recognise the connection as a table so I am not sure how to do this.

Thank you,

davidebacci · Accepted Answer · 2022-11-14 14:04:07Z

1

Load it to the Excel data model which doesn't have a 1m row limit.

You cannot load from PQ to Access (nor would you want to).

answered Nov 14, 2022 at 14:04

davidebacci

31.4k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Load Data from Excel Power Query to Access table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related