drewduncan
Programmer
Can anyone help:
I want to read data from a csv file which will be used to create records within a table - called Jobs.
The files can have various rows BUT each row always has 13 columns. Each column or data separated by a comma will be entered into a different field within the Job Table.
One row from the text file will contain information such as RefNo,CustomerName,HouseNumber,StreetName,Town,PostCode etc
RefNo will be copied into the RefNo field of the Jobs table, CustomerName will be copied into the CustomerName field of the Jobs table and so on.
Any help on how to do this would be greatly appreciated.
Cheers
I want to read data from a csv file which will be used to create records within a table - called Jobs.
The files can have various rows BUT each row always has 13 columns. Each column or data separated by a comma will be entered into a different field within the Job Table.
One row from the text file will contain information such as RefNo,CustomerName,HouseNumber,StreetName,Town,PostCode etc
RefNo will be copied into the RefNo field of the Jobs table, CustomerName will be copied into the CustomerName field of the Jobs table and so on.
Any help on how to do this would be greatly appreciated.
Cheers