---
title: "How to read excel data directly into SQL server 2005?"  
description: "How to read excel data directly into SQL server 2005?"  
author: "Chris Anderson"  
published: 2011-08-12  
updated: 2020-09-18  
canonical: https://www.mindstick.com/interview/1144/how-to-read-excel-data-directly-into-sql-server-2005  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to read excel data directly into SQL server 2005?

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',\
'Excel 8.0;Database=C:\Source\Addresses.xls',\
'SELECT * FROM [Sheet1$]')

## Answers

### Answer by Chris Anderson

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',\
'Excel 8.0;Database=C:\Source\Addresses.xls',\
'SELECT * FROM [Sheet1$]')


---

Original Source: https://www.mindstick.com/interview/1144/how-to-read-excel-data-directly-into-sql-server-2005

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.