Hi,
Could anyone point me in the right direction on this. I have a service running on a remote server that sends files to my local server periodically (every minute or so). The file that is sent is a simple text delimited file and it gets dropped in a specific directory. I am looking to set something up where as soon as the file gets dropped in the local directory, I push the file into a specified access table with identical fields in my access database. My delima is that I have no problem importing or pulling data into the database, but I really don't know how to go about pushing the data into a specified table in the database. I am thinking I will need to write some service that detects the new file, and runs some insert statement moving the records into the table, and then maybe archiving the original file in a separate.
Has anyone done this before, I am think maybe there is a commercial service out there that already does this type of thing ??
Thanks
Could anyone point me in the right direction on this. I have a service running on a remote server that sends files to my local server periodically (every minute or so). The file that is sent is a simple text delimited file and it gets dropped in a specific directory. I am looking to set something up where as soon as the file gets dropped in the local directory, I push the file into a specified access table with identical fields in my access database. My delima is that I have no problem importing or pulling data into the database, but I really don't know how to go about pushing the data into a specified table in the database. I am thinking I will need to write some service that detects the new file, and runs some insert statement moving the records into the table, and then maybe archiving the original file in a separate.
Has anyone done this before, I am think maybe there is a commercial service out there that already does this type of thing ??
Thanks
