Export To Excel

[Eranka]

Hi

DoCmd.TransferSpreadsheet acExport, 10, "Table1", curPath, -1

This is the code currently im using to export a table to excel spreadsheet, but the issue is when i run the above code it exports all the fileds in access table.

Table 1 has 5 fields (UID,Uname,Uaddress,Uemail,Time)

What i need is only 4 fields to imported to excel (UID,Uname,Uaddress,Uemail). Does anyone know how to this part?



Appreciate your help

[ranman256]

Use a query ,instead of the table,to get the fields you want.

[Eranka]

Hey ranman

Awesome. That worked