Link to home
Start Free TrialLog in
Avatar of SeTech
SeTechFlag for United States of America

asked on

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.
Avatar of lcohan
Flag of Canada image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial