I have my bulk data in sql server. How can i send this data to my excel spreadsheet?
Similarly, i have an excel spreadsheet with bulk data. How can i save this data in sql server?
plz rep asap.
thanx and regards
View Complete Post
Trying to import spreadsheet from Excel 2007 to a table in SQL Server 2005, when I follow the steps for a linked server ,, I am able to create a linked server but because the instructions I am following are calling for a Microsoft 4.0 Jet something or another
as "Provider" and I do not have that I am getting an error.. I have the a list of providers but the 4.0 Jet is not one of them...
Any help is greatly appreciated
I'm trying to import (Custom Lists >> Import Spreadsheet) into WSS 3.0 and I'm getting the following message:
Refers to the _layouts
You are not authorized to view this page. You might not have permissions to view this direcotyr or page using the credentials you supplied. [More stuff here.]
Http ERror 403 - Forbidden
Is this just a permissions problem or is there some other underlying issue? Should you be able to upload an Excel spreadsheet (with links) into a Custom List?
I'm tried SELECT * INTO XXX FROM OPENROWSET alongwith Microsoft.ACE.OLEDB.12.0.
Apparently the query requires the sql account to have SYSADMIN privileges.
Considering that SYSADMIN should not be provided to a database account on a Production Server, I tried using the Linked Server method.
Following is my code.
Exec sp_addlinkedserver 'AB2','Ace 12.0','Microsoft.ACE.OLEDB.12.0','\\220.127.116.11\sagarr\Test1\cpc\c2\AB2.xlsx',NULL,'Excel 12.0;IMEX=1'Exec sp_addlinkedsrvlogin 'AB2','false',NULL,NULL,NULLgoSELECT * INTO [CPCAB2.xlsx] FROM OPENQUERY([AB2] ,'SELECT * FROM [Sheet1$]')Exec sp_dropserver 'AB2','droplogins'
Now i get the following error
Error.15247-User does not have permission to perform this action
My Excel file, Database and Windows Application run on separate machines.
i have provided the following privileges
GRANT ALTER ANY LOGIN TO sqlaccountGRANT ALTER ANY LINKED SERVER TO sqlaccountEXEC sp_configure 'show advanced options', 1RECONFIGUREEXEC sp_configure 'ad hoc distributed queries', 1RECONFIGUREThe DisAllowAdHocProcess in