I have a task to complete here, and I'm having a hard time finding information on it.
I have an HP-UX server that keeps all of the data that I can use. I have a routine setup that creates 3 flat files with the information I need.
2 of those flat files are used to fill data to one access table, and the other flat file is used to fill data in a different access table.
I am familiar with using update queries to change the information in the fields in a record. What I need to do here is automate the process somehow. I need a way to import data from a .CSV file to update records in a table, and do this without any user intervention, other than perhaps a mouseclick or two to start the process.
The final goal is a batch file on the HP-UX box that creates the 3 flat files, and a timed event that moves these files to our NT server. Another timed event runs the update query. This would happen 2 or 3 times a day.
Any suggestions would be greatly appreciated. Thanks in advance!
I have an HP-UX server that keeps all of the data that I can use. I have a routine setup that creates 3 flat files with the information I need.
2 of those flat files are used to fill data to one access table, and the other flat file is used to fill data in a different access table.
I am familiar with using update queries to change the information in the fields in a record. What I need to do here is automate the process somehow. I need a way to import data from a .CSV file to update records in a table, and do this without any user intervention, other than perhaps a mouseclick or two to start the process.
The final goal is a batch file on the HP-UX box that creates the 3 flat files, and a timed event that moves these files to our NT server. Another timed event runs the update query. This would happen 2 or 3 times a day.
Any suggestions would be greatly appreciated. Thanks in advance!