We currently receive data files that arrive as txt files. We need a script or process that can import these files into an SQL database that was created for this data.
The data comes in a comma delimited file. The database is setup with fixed positions for the fields. We have been provided with a document for the database that specifies the type of fields, length, fixed position, etc. for each table which we used to create the database.
The data is all in one file, but each line goes to a certain table.
We will receive about 50 of these files each month so we need a very automated process.
I will attach an image of the sample data and a page from the document that describes the database.