Read Excel Data Into SQL Table

This is a more frequently asked question. How to read an excel sheet in sql server as a table or query in an excel sheet?

Trust me there’s no rocket science behind this, it reads data using OLEDB driver. As you can see below, I have used OPENROWSET command to fetch excel data using OLEDB. Again OPENROWSET is a big topic, will discuss more about this command in future blog post.

Note: You can use where or other sql clauses or commands like wise a table.

Couple of configurations needs to be done prior fetching the excel data.

Prasad Sahoo

Prasad Sahoo, is an enthusiast of Microsoft technologies in general and a passionate database professional, mainly focusing on SQL Server performance tuning and business intelligence. He has contributed a long time of his career working on SQL Server and other RDBMS. If he is not busy with SQL stuff then he must be watching some Hollywood movies.

Leave a Reply

%d bloggers like this: