Display the result in excelsheet from Access table

[aman1234]

Hi guys

I want to display the result of a query from Access table to Excel spreadsheet. I have written the following code to fetch the data from the Access table but have no idea how to display that in excel sheet. Can anyone please help me out in this.

Please Login or Register  to view this content.

Thanks in advance!!

Aman

[T-J]

Range.CopyFromRecordset could be useful.

Quote from Excel Help:

Copies the contents of an ADO or DAO Recordset object onto a worksheet, beginning at the upper-left corner of the specified range.

Please Login or Register  to view this content.