Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
junior6202
Starting Member
45 Posts |
Posted - 2014-07-23 : 16:29:28
|
Hi All,I have this task that i'm working on, which involves a Software that is set to give us two Excel.csv files with data each day. Now I want to create a SQL database and possibly create some sort of Macro that automatically imports those Excel csv files to the SQL database. Any Ideas please feel free to shared them with me. Thanks in advance |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-23 : 16:32:18
|
Have a look at SSIS. You can create a package that does the import, and you can schedule that package to run on a schedule via the SQL Agent.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
junior6202
Starting Member
45 Posts |
Posted - 2014-07-23 : 16:48:44
|
Thank you Very Much Tara. I was actually reading about SSIS a few minutes ago. I'm going to give it a try. |
|
|
|
|
|