Not allowed to import

[Sashanan]

When trying to import data from an Excel file to SQL Server 7.0, I get the following error:

"You could not create a publication because this server has not been configured for publishing. Contact your system administrator to configure this server for publishing."

I've got full rights on the Excel file in question, am logged in under Windows 2000 with full access rights, and I am the dbo on the SQL Server database I am importing to, yet I still seem to be denied access.

Can anybody tell me what the problem might be? Does "this server has not been configured for publishing" refer to SQL Server or the NT server it is running on? If the former, what steps should I take to configure it for publishing?

Thanks in advance!
"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[tlbroadbent]

Looks like you are using the wrong tool for importing. You should be using the DTS Import Wizard. Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Sashanan]

I was using that. Fortunately I have figured out the problem - the table I was trying to import the data to was owned by dbo, and I was currently logged in as another user. No wonder I was shut out.

Thank you for your time.
"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)