The most important thing, though, is that you can aggregate before you send the data. It is neater than SSIS too, and more versatile. It is quicker than automating Excel and you can do it without requiring a copy of Excel. The most important direction is from Excel to SQL Server, of course. It is reasonably easy to insert data from Excel into SQL Server, or the reverse, from any other ODBC database to any other, using PowerShell. Getting Data between Excel and SQL Server using ODBC - Simple Talk
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |