I have a csv file that contains data, but there are no columns defined and the data is the same place all the time but spread out over many lines.
Example of row:
"Purchase Order No.","Customer ID","Salesperson ID","Shipping Method","Payment Terms","Req Ship Date"
Another row would have bill to name and ship to name
next row has their address
next row has city, state and zip.
Is there a way to input into access using vba.