i got it figured out it was a issue of the account not having access on the share, NTFS persmissions where not enough I had to give them access to...

ever mind solved, needed to add permissions to share and to NTFS, hate Win 2008

Actually i should say Andrew you rock, thank you

gentlemen,

all of you rock, thank you very much fro the help.

Hi,

Thanks for sticking with me and helping, i am getting the following error.

Msg 537, Level 16, State 5, Line 8

Invalid length parameter passed to the LEFT or SUBSTRING function.

Hi,

Thanks for the reply it works good except its being limited on the SN amount of characters, is there a way to go to the next semicolon and get the...

hi,

Ok tired it and it works, thanks for the help.

ok, when you say mapped, I take it you mean setting up a mapped drive, this I did not do on the server. I just changed the shared from...

Hi,

ok tried with D drive and still same issue, I did login in from my client to the server witht he SA account and i was successful in runnign the...

Hi,

The drive is not mapped to the sql server at all. I checked to make sure and the linked server allows UNC's. i will try sharing the D...

hi,

negative, the file is on our web server on a shared drive where personnel upload files along with programs, we don't allow any access to sql servers other than through...

I can create linked servers with my regular login accoutn to all my sql servers, oracle servers and query them jsut fine, its just excel spreedsheets and access databases that...

It is shared drive name of our d drive. All permissions have been given to it. It works from the sql server itself. i logged in my...

/****** Object: LinkedServer [AIRPERSONNEL] Script Date: 11/03/2011 11:04:03 ******/

EXEC master.dbo.sp_addlinkedserver @server = N'AIRPERSONNEL', @srvproduct=N'Excel', @provider=N'Microsoft.ACE.OLEDB.12.0', @datasrc=N'\gmnc2-j6ops-a7\autod\Database Imports\Personnel.xlsx', @provstr=N'Excel 12.0'

/* For security reasons the...

I am trying to add that Excel spreadsheet, I logged on to the sql server and opened SSMS from here with my admin privledges and was able to create the...