How to Synchronize Excel With MS SQLby Bennett Gavrish
When working with the Microsoft SQL Server Management Studio software, you have the ability to use different types of files as the back-end for your SQL. For example, you can set up a SQL connection that will synchronize a database with a Microsoft Excel spreadsheet file. In order to set up a connection between Excel and SQL, you must know the exact filename and path for the Excel file.
Launch the Microsoft SQL Server Management Studio on your PC server.
Double-click on the "Server Objects" directory in the "Object Explorer" window.
Right-click on the item labeled "Linked Servers" and choose the "New linked server" option.
Click on the "General" tab in the pop-up window that appears.
Enter a label for the new server connection and select "Other data source" as the connection type.
Open the "Provider" drop-down list and pick "Microsoft Jet 4.0 OLE DB Provider."
Enter "Excel" in the "Product Name" field.
Type in the exact path and filename for the Excel spreadsheet you want to synchronize in the "Data Source" section of the window.
Set the "Provider String" field to "Excel 8.0."
Press "OK" to save the settings and synchronize the Excel file with your SQL server.
Items you will need
- photo_camera Thinkstock Images/Comstock/Getty Images