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