请按照下列步骤操作：

如何将Excel与SQL Server链接服务器和分布式查询一起使用 [ ^ ]

如何：连接到SQL Server Express数据库中的数据 [ ^ ]

Hi All,

I have got an Excel file that contains some data and this excel is updated on a regular basis. I would like to somehow point this file into a database on sql server or point a database on sql server to this file if you will.

My Question

is possible to point this excel file to a database into sql server so that the data contained in this file is also contained in the database on sql server? also when the excel file is updated , is it possible that the DB on sql server automatically updates accordingly? is so , How would i go about in achieving thus?

Thank you for your time.

Follow these steps:
How to use Excel with SQL Server linked servers and distributed queries [^]
How to: Connect to Data in a SQL Server Express Database[^]