<div>
<div class="content wysiwyg-content">
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.<br />
Thanks
</div>
</div>


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

How can I schedule SQL Server Agent to load data from an excel file on a daily basis.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.