Excel Front End for SQL Server
I'm using Excel as a front end for a local copy of SQL Server 2000 on my
WinXP machine.
I'm having no problem using SQL to retrieve records from my SQL Server.
However I cannot delete records in my SQL Server from Excel. I think it's a
permissions issue, but I'm not sure how to alter the permissions or which
permissions to alter.
Thanks,
Wayne C.
.
Relevant Pages
- Re: How to determine if a user has a permission programmatically?
... I need to determine in advance if a user logged on to SQL Server 2005 can ... sp_addrolemember and ALTER LOGIN). ... determine programmatically if a user has specific permissions (ALTER ANY ...
(microsoft.public.sqlserver.security) - Re: SSIS and unicode data types
... my varchar columns are at most 50 characters. ... destination column in the SQL database destination is only varcharor ... How do I get an Excel column of datatype ... It left SQL Server as a VARCHAR and went into Excel, ...
(microsoft.public.sqlserver.dts) - Use Single Sign on to connect to sql server
... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
(microsoft.public.sharepoint.portalserver.development) - Re: Excel 2007 connection
... The Feature pack also contains the SQL Server Client ... You should install it. ... so I installed them both as I do for Excel 2003. ...
(microsoft.public.sqlserver.olap) - Re: Trasfer data to SQL Server
... Do you know how you would execute the DTS package from excel? ... Currently Using SQL Server 2000, ... This will place a SQL Server icon onto the DTS ...
(microsoft.public.excel.programming) |
|
