Received the following error message when trying to import a list from SharePoint 2010:
'An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.'
The SharePoint List and all columns have unique names...
The other error may also appear:
'The multi-part identifier "Microsoft.SharePoint.Client.FieldLookupValue" could not be bound.
Do you want to cancel the import? Click no to ignore the current error(s) and any additional errors and continue importing. Toad will not prompt you again if another error occurs.'
WORKAROUND:
None.
STATUS:
Enhancement request CR100792 has been submitted to Development for consideration in a future release of Toad for Data Analysts.
