I am trying to import a spreadsheet into a SQL Table.
I have been trying to do this for 3 days no with no luck. Its beginning to get really frustrating.
By the looks of it the best way is to use linked Servers. I will attach how I have setup the linked server as a picture).
I then use the attached code to do the import and recieve the following error:
" Msg 208, Level 16, State 1, Line 3
Invalid object name 'EXCELLINK'. "
I have run " select * from sys.servers " and it returns that there is a Linked Server called EXCELLINK.
Can anybody suggest anything?
SELECT * INTO sanctionslist FROM EXCELLINK[sanctionslist$]