VBA ADO - .CopyFromRecordset not working?

Hi,

I am simply trying to import an Access query table to my excel spreadsheet. Problem is, I only get ONE column to return to my spreadsheet, which is "ID". No others populate.

Calling the procedure:

Please Login or Register  to view this content.

Sub:

Please Login or Register  to view this content.

Thanks for the help, folks.

Hi,

I solved the issue.... Embarrassingly, my Query returned no data because... well.. there was no data to be queried in the other fields!

Thanks