Rich,

I am bouncing my head against the wall!

Installed the SP2 and the problem is just...dissappeared!

Rich, Sugesh and all of you guys thank you very much, very appreciate your time and...

Hi Sugesh,

Added the user to the sysadmin role and it works now.

So does this mean that without SysAdmin server role it won't work?Thanks

Cheers

Ben

Hi Sugesh,

Here are my syslogin properties:

sid-0x08BDEBF1DD75AA48818724C2632A96A8

status-9

createdate-2007-07-05 12:26:20.403

updatedate-2007-07-05 15:34:10.477

accdate-2007-07-05 12:26:20.403

totcpu-0

totio-0

spacelimit-0

timelimit-0

resultlimit-0

name-bkovac

dbname-master

password-#########

language-us_english

denylogin-0

hasaccess-1

isntname-0

isntgroup-0

isntuser-0

sysadmin-0

securityadmin-0

serveradmin-0

setupadmin-0

processadmin-0

diskadmin-0

dbcreator-0

bulkadmin-0

loginname-bkovac

Cheers,

Ben

Hi Mark,

This is not related to my previous posts, simply just created a LOGIN account for logging in to SQL Management Studio, also created a user and mapped it to...

Hi Sugesh,

Yes I know, that was my first thought,clicked on the SQL server->Properties->Security and changed to SQL and Windows Authentication mode.Then restarted SQL, tried to log on and failed withe...

Tebogo,

What SQL Server you have installed?I think under Express Edition there is no Import,Export service,so check your Edition of SQL.

To get the SSIS services I guess you want to use...

Hi Jeff,

thanks for your comment,even if my excel file is only 1 table/sheet, your suggestion is interesting...

So what you are saying is, if I have more than one excel table/sheet...

Thanks Sugesh, Crispin

Sugesh - As I found out whatever method I use (creating linked server, using Tasks/Import Data or your code version) the solution is Miscrosoft's OLE DB provider and...

The following sample script can be useful. Similar result is achievable, as when you using linked server, if you right click on the database and going to tasks/import data and...

Having the question basically. What I have experienced is that you can use Linked Server functionality under SQL2005, info is on:http://support.microsoft.com/kb/321686;

Anyway, tried Import wizard, but were ending up...

Thanks Sugesh,

You are right the OPENDATASOURCE is another option to importing excel data into SQL, the use of them depends on how frequently you accessing the particular Excel data file.As...