Hi,
I have an excel file that I need to import to my SQL server once in a while (on a fixed basis,like once a week). The excel file itself is update whenver needed, and everytime we updated, we simply need to wipe out the whole SQL table and replace it with the current Excel table.
Is there a way to creat a "routine" that runs automatically on a regular basis that wipe out data from the table (ZAPing it in Foxpro term) and import the excel file into the SQL server.
I am not familiar with stored procedure though.