Upload of Excel to SharePoint via MS Access connection now fails
We have a process that we have been using for over a year to import data from XLS to Sharepoint via a connection with MSAccess. Just recently the process is now failing and I am having to do the upload in chunks (200 or 300 records at a time). The import wizard ends with the following message: database or object is read only I use to be able to import 6k plus records this way now it appears to dies after 200 sometimes 300 records. What should I look at???? Access 2010 XLS 2010 SharePoint 2007
June 22nd, 2011 7:23pm

Hi Pinkston, The most common cause of this issue are: 1. The file that you are importing or that you are trying to export does not have a recognized file name extension. 2. The file name is surrounded with quotation marks, for example “C:\Employees.xls”. 3. A carriage return/line feed (CTRL+ENTER) is at the end of the file name in the FileName property. You can refer to the following two KB articles to get detailed information and solutions for this problem: http://support.microsoft.com/kb/245407; http://support.microsoft.com/kb/304146. Thanks & Regards, Peng Lei
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 5:15am

But I am doing this with the wizard and it was working find for months.Matt Pinkston
June 23rd, 2011 2:11pm

I read both posts above and neither apply.... I am using an import wizard in access to a table that is connected to sharepoint list. the file I am importing is a xlsx fileMatt Pinkston
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 2:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics