sp_addlinkedserver procedure not linking Excel source

Question

I am attempting to link an Excel source to a SQL Server DB on the Go Daddy website.  When I execute the sp in SQL Server, it shows it executed successfully, but no data is linked.

This is the main part of my procedure:

     EXEC sp_addlinkedserver
@server = 'XLHybrid',
@provider = 'Microsoft.ACE.OLEDB.12.0',
   @srvproduct = 'Excel',
   @provstr = 'Excel 12.0 Macro',
   @datasrc = 'C:\Database\XLHybrid.xlsm'

What's the problem here?

Answer 1

isn't @datasrc = 'C:\Database\XLHybrid.xlsm' specifying a file on the Go Daddy server and not your PC? Do you really have a file at that path on the Go Daddy server? The doc says that this is the location as interpreted by the OLE DB provider:

sp_addlinkedserver (Transact-SQL)

[ @location= ] 'location'

Is the location of the database as interpreted by the OLE DB provider.

location is nvarchar(4000), with a default of NULL. location is passed as the DBPROP_INIT_LOCATION property to initialize the OLE DB provider.

Copy the file to the Go Daddy server and use that path and file name and see if it works then.

For what it is worth, when I run the command on my database it works without any error, there just isn't any data there either.