• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

sp_addlinkedserver procedure not linking Excel source

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:


Your thoughts, comments?


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

Open in new window

0
brohjoe
Asked:
brohjoe
  • 4
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>but no data is linked.

how do you "see" that?

>   @datasrc = 'C:\Database\XLHybrid.xlsm'
you are aware, I presume,  that the file has to be on the sql server box, and not on your PC, unless both are the same machine...
0
 
brohjoeAuthor Commented:
Ok.  So how do I link a local Excel file to a remote SQL Server DB?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you cannot do that. you have to get the file copied to the server.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
brohjoeAuthor Commented:
Is it possible to upload the files remotely?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
sure, if you have some FTP or other "upload" mechanism. but that is another question ...
0
 
brohjoeAuthor Commented:
I guess you are probably right.  I've been searching online off and on for over a month and I have not been able to find any examples that would allow you to link remotely.  I just needed confirmation.  Thanks again angellll.
0
 
brohjoeAuthor Commented:
Angellll is always quick with his responses and is usually very accurate.  I can always feel confident that his answers are correct.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now