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...
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
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...