Exporting field to excel

[Kipster1203]

here is the code that I am trying but I'm getting compiling errors! Can someone help?

    Dim xlApp As Excel.Application
    Dim xlWrkBk As Excel.Workbook
    Dim xlSht As Excel.Worksheet
    Dim myRec As DAO.Recordset
    Dim StartDate As DAO.Field


        Set xlWrkBk = GetObject("W:\edsplus\applications\0cmad\cmad_chart_spreadsheet.xls")
        Set xlSht = xlWrkBk.ErrorOverTime

        Set myRec = CurrentDb.OpenRecordset("Select Chart Form")
        Set StartDate = myRec.Fields("Start_Date")

        myRec.MoveFirst

        xlSht.Cells(1, "K") = StartDate
        xlWrkBk.Save


.....

[NTC]

Is the goal 'exporting field to excel' ? Is so, have you stepped thru the vanilla export method manually?

[Kipster1203]

I have no idea what that is

[NTC]

ah well - one must have an Access text book in the version one is working in. Available at Amazon or any big box book store. This topic is covered in all. File/Export.

There is also an advanced feature called an Export Specification, it isn't intuitive and may not be needed - but refer to that term also as your explore this feature of Access.

[Kipster1203]

Everyon I ask has no idea what that method is, and neither does my access book, or google. Please enlighten me on this method

[NTC]

make your recordset - either a table or a query. highlight it...then go to File / Export and follow the wizard....