Importing Data from an Access Database into excel, without linked tables

[Ostrich21]

Hi All,

Bar those who don't believe/celebrate in Christmas, Hope you all had a good Christmas and New Year celebrations.

I have two sets of data, lets call them 2013 and 2014. I have a Spreadsheet already set up in excel, but currently I just past this information into a tab in excel (which isn't ideal at all), and given the data is growing, is slowing down my excel spreadsheet a lot.

I have some experience with Access, SQL and queries.

What I have done thus far is to link my Access DB with Excel, run a query and paste the resulting table from the query into excel all using VBA (easy peasy).

The problem i have is that the table is still linked, and i do not want or need it to be linked. I know that there is a "Unlink" Option, which is not what i need, and also a "Convert to Range" option which is also not what i need, but closer. This got me thinking, is it possible to import the data into an array (all in VBA in excel from the query in the SQL) and then i can paste that information into my Excel spreadsheet, or is there a better method?

Would appreciate any Help.

Thanks

Claudio

 

[Norie]

Claudio

You can use ADO to connect to the database, run the query and return the results in a recordset.

Then you can transfer the data from the recordset to the workbook.

 

[Ostrich21]

Thanks Norie.

I've not used ADO much (at least not knowingly). Could you direct me to a guide on using ADO?

Thanks