I understand how to import data from Excel into a Sharepoint list. We have a problem where we have 200-300 word docs, each consisting of 3 or 4 tables of information. I want to get this information into a single list in Sharepoint without having to convert and clean the data in excel first
You would have to build a script that pulls the tables from your documents and write them back to SharePoint. This could be done with a macro, but to me it seems to be more work than just moving the content from Word to Excel or Access, then pushing it to SharePoint.