I am trying to link a text file to my ADP to import results that are emailed to me daily. I have written the stored procedure to append them into the proper table but cannot get the records from the text file to the temporary table within the SQL Server. The only workaround that I have come up with is to create a MDB that links the two together and with a query sends the text file to the temp table on the SQL Server, then I have to go into the application and finish the import.
I would like to be able to create the import directly with a single mouse click within the application. Can anyone indicate how to attach the text file to the ADP and possibly delete the file after import? or am I asking too much?