MS Access data

[Susana]

Hi all, I have a simple question. I am trying to fill an Excel worksheet by using Visual Studio 2005. The way I tried to do this was by getting data from Microsoft Access tables, by reading each record and copying it into the new Excel Worksheet, but i found out that is really too much faster to select the records from Access, copy them, and paste them into the Excel worksheet all at the same time, instead of copying every single record row by row. Any ideas of how to do this? I tried by using this code:


objDataSet.Tables("EMPLOYEES_DATA").Select()
objDataSet.Tables("EMPLOYEES_DATA").Copy()
oExcelWorksheet.Range("B7").Select()
oExcelWorksheet.Paste()

But it doesnt work. Thanks in advance!!