workgroup information file does not exist
In SQL Server 2000 I have created a linked server. It was to link me
with an Excel file.
I received a message:
[OLE/DB provider returned message: You can't execute the application.
Workgroup information file does not exist or was opened in exclusive
mode by another user.]
I know about system.mdw, but it is linked with Access. And what about
Excel.
May anyone help me?.
.
Relevant Pages
- workgroup information file does not exist
... In SQL Server 2000 I have created a linked server. ... with an Excel file. ... [OLE/DB provider returned message: ... (comp.databases.ms-sqlserver) - RE: SSIS truncates and/or rounds the data
... I tested the issue on my side but I didn't reproduce the issue. ... The data type of the data column is Number which decimal places is 12. ... Use SQL server Import and Export wizard to import data from the Excel ... Choose the excel file as data source file. ... (microsoft.public.sqlserver.datawarehouse) - Re: Excel field returning NULLS in SQL field...
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... We have other> DTS packages which do what you tested and work fast and fine. ... With the> excel file which gives us trouble it appears that it is generated from a> crystal report and exported. ... (microsoft.public.sqlserver.dts) - RE: Linked server 7302 error
... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ... (microsoft.public.sqlserver.connect) - Re: TransferSpreadsheet to .ADP dbo table
... I use the excel file as a linked server by running this Stored ... TransferSpreadsheet is a powerful command. ... you may well be right about the Transfer commands not being squeaky ... (comp.databases.ms-access) |
|