QUESTION:
Why am I getting the error "Error: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information" when trying to export to Access?
ANSWER:
This error occurs when trying to export more than 255 fields to an Access table.
This is a limitation of Access and the only workaround would be to export less than 255 fields, or export to a .csv or .xlsx file.
