I have a file generated automatically from a vehicle tracking unit. The file is excel csv format but the data is organized in a very strange manner as shown in the attachment. I would like the report to be imported into an access table so that the table is a below:
field Truck value 1
field date value 01/09/2015
field chemical value Aquareslin
field rate value 1.470
field driver value Carlos
Field Route value None
Field Miles value 24.3
Field Acres value 544.5
Field Ounces value 834
How do I go about doing this?
Any help would be greatly appreciated
Thanks
Alan