Hello,

I have an excel spreadsheet that contains some imported tables. The tables contain close to 1 million records each. The tables come from an Access query that I import using Data --> Get External Data --> From Access. The problem is, the import sets the data up as an excel table which takes up a huge amount of space and makes my spreadsheet run very slow. Is there any way to take the data in the tables and have it contained in a standard un-table-formatted way?

Thank you for your help.

Break the link between Excel and Access.

Record a macro of you doing the import and show us the resulting code. That might reveal more.

Why are you importing to Excel?

Access can do many of the same things that Excel can do. Plus Excel was not made for dealing with loads of data, Access is!

When you use the External Data function it will take the data from whatever source and place in rows and columns in your spreadsheet. That's the only way Excel know how to handle it. I really don't know what you mean by "a standard un-table-formatted way".

So you need to provide more information about what you are doing and why if you want us to help. My suggestion is to filter and/or summarize the data in Access and only import the data you actually need into Excel (if in fact you need to use Excel at all).