I have to copy data from Access tables to excel using vba. I have a userform in access and based on the selection by the user the data will be queried and has to be exported to excel. Can anybody please help? I tried using the DoCmd.OutputTo Command but that transports the result to one workbook and I have to query separate recorsets from 10 tables. So the DoCmd.OutputTo will open up 10 workbooks and I have to get all the data into one workbook. I think I should be using the recordset function but just dont know how to proceed. Can anybody please hlep?