Skip to content
SQL-Steve.com

SQL-Steve.com

A place to learn new techniques in the Data Analytics world

How to store Excel files In SQL Table

We need to do this all the time. This is just one example of a way to load multiple Excel data files into a table.

http://www.sqlservercentral.com/articles/OPENROWSET/163645/

The same concept could be used to load flat files.

Author StevePosted on 12/12/2017Categories Development

Post navigation

Previous Previous post: Why Scalar Functions Can Be Costly
Next Next post: SQL Server Execution Plan

Subscribe

Sign up for email notification: be the first to see new posts!
Loading

Categories

  • Administration (1)
  • Books (2)
  • Development (29)
  • SSIS (2)
  • Uncategorized (5)
SQL-Steve.com Proudly powered by WordPress