用oledb打开XLS文件时出现问题 [英] Trouble to open XLS file with oledb

问题描述

当我尝试打开一个xls文件时，我收到这个错误：

When I try to open an xls file, I get this error :

Rhe Microsoft Office Access database engine cannot open or write to the file ''. 
It is already opened exclusively by another user, or you need permission to view and write its data.

我做了几个访问，但我一直关闭并处理连接。它在我的DEV PC上。在服务器上我得到这个错误：没有对该文件的读/写访问。此文件位于\\\
etworkdisk\directory1\Files

I do several access but I close and dispose the connection all the time. It's on my DEV PC. On the server I get this error : Don't have read/write access on the file. This file is on \networkdisk\directory1\Files

我将使用ACE.OLEDB，因为Jet未在x64服务器上运行。

I'll use "ACE.OLEDB" because Jet is not running on x64 server.

任何想法？

谢谢，

推荐答案

在我的情况下，这是一个尚未关闭的文件流。

In my case it was a file stream that had not been closed.

这篇关于用oledb打开XLS文件时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！