Hi,

I am using Access 2003 front-end with SQL server 2005 linked-tables.

The requirement is to export data to existing Excel 2003 files that contain 1st row headings and hidden columns.

I have some vba experience and need to export various recordset fields to populate various excel columns.

Recordset
rstCustomer (Customer_Name; Customer_Address; Rep_Code; Source_Id)

Excel
Rep.xls (Rep (S); Cust_Name (I); Cust_Add (S); Source (S))

Where
Cust_Name (I) = Customer_Name
Cust_Add (S) = Customer_Address
Rep (S) = Rep_Code
Source (S) = Source_Id

Please can anyone assist?

Thanks in advance,




Neal

A Northern Soul

__________________
Neal

A Northern Soul