Reputation: 35
Link Excel sheet to SQL Server
Is it possible to link an Excel sheet to a SQL Server database? I want to be able to join the Excel columns to the tables in SQL Server and run queries. I can find plenty of examples to link the tables from SQL Server to Excel, but I want the other way around.
Thank you in advance for any suggestions.
Upvotes: 0
Views: 866
Answers (1)
Reputation: 487
Use SQL Server Import and Export Wizard.
Set your worksheet as a Data Source
Excel file path Specify the path and file name for the spreadsheet from which to import the data. For example, C:\MyData.xlsx or \Sales\Database\Northwind.xlsx. Or, click Browse.
Browse Locate the spreadsheet by using the Open dialog box.
Excel version Select the version of Excel that is used by the source workbook.
Upvotes: 1
Related Questions
- Connect to SQL Server query from Excel
- SSIS Extract links from Excel cells to load into SQL
- Retrieve hyperlinked data in excel in VB
- How do I configure an Excel file as a Linked Server in SQL Server?
- Activating SQL imported hyperlinks within Excel
- insert excel sheet to sql database
- sql linking to excel
- In Excel 2007, link to a SQL Server DB with the data connection not possible
- Excel Front end to Sql Server
- Sql Server to Excel via a Web Service