Recent content by Daved99

  1. D

    Export table usng VBA into seperate columns

    Yes, absolutley. Thanks for the suggestion :)
  2. D

    Export table usng VBA into seperate columns

    Sorted.... Managed to find smething similar and rework it to get it the way I need it to work. Needs a little tidying up but works exactly as needed: Dim xlApp As Object Dim xlWb As Object Dim xlWs As Object Dim strDB As DAO.Recordset Dim fldCount As Integer Dim recCount As Long Dim iCol As...
  3. D

    Export table usng VBA into seperate columns

    The first image shows a small sample of the the current list in a table. the second imahe shows the first 30ish lines (need to be 99 in total) currently across 3 columns - but this could increase depending on the number of records to export. Hope this makes sense. Dave
  4. D

    Export table usng VBA into seperate columns

    Hi, I have a table containing historical Vehicle identification numbers. I need to be able to export these records (only the VIN number, not the compete line of data) either into an excel spreadsheet or produce in a tempotary access table or even just display in an access query (it doesnt...
Top Bottom