דעם וואָך, מיר לעסאָף ריפּראַדוסט אַ פּראָבלעם אַז האט שוין געמאלדן דורך אַ ווייַט באַניצער: ווען זי געפרוווט צו אַרויספירן די אינהאַלט פון אַ רשימה צו עקססעל, דאס וואָלט ויסקומען צו אָנהייבן ארבעטן, אָבער דעמאָלט עקססעל וואָלט קנאַל אַרויף אַ טעות: "Cannot get the list schema column property from the SharePoint list". She was running office 2003, windows XP and connecting to MOSS.
איך געזוכט דעם ינטערנעץ און געזען עטלעכע ספּעקולאַציע אָבער גאָרנישט 100% definitive. Hence, דעם פּאָסטן.
די פּראָבלעם: עקספּאָרטינג אַ מיינונג צו עקססעל אַז כּולל אַ דאַטע (דאַטע = די דאַטן טיפּ פון דעם זייַל).
What worked for us: Convert the date to a "single line of text". דעמאָלט, convert it back to a date.
That solved it. It was nice to see that the conversion worked, פאקטיש. It was quite nervous that converting things this way would fail, but it did not.
This bug has thrown a huge shadow over the date data type in the client’s mind, so we’re going to be seeking out a definitive answer from Microsoft and hopefully I’ll post and update here in the next short period of time with their official answer and hotfix information.
Other references:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2383611&SiteID=1
<עק>
דאַנק. This worked for me as well. אָבער, I had to switch between date/time and single line text multiple times.
•
Error message when you try to export a custom list: "Cannot get the list schema column property from the SharePoint list"
The DATE field requirement is changed in a custom list on a Windows SharePoint Services 3.0 Web site. If you try to export the custom list to a spreadsheet, Microsoft Excel starts, and a workbook that contains the data does not appear. Additionally, you receive the following error message: