How can I schedule SQL Server Agent to load data from an excel file on a daily basis.
How can I set up a SQL Server Agent Job to connect to an excel file and bring the data into a table in SQL. So for example if I have an excel spread sheet with two columns Salesman and Items and I want to get that data into an SQL 2008 database in table Sales. I want to schedule it on a daily basis. I could use the import task, but would not want to do that manually each day.
Thanks