Import from Sharepoint

[Jim]

I'm new to importing/exporting data from Sharepoint and have a question. I'm
able to link Access tables with Sharepoint Lists, that part is set up. There
are 16 Sharepoint Lists that were created from 8 Excel workbooks. What I'd
like to do is have my users update their workbook which is in the Shared
Documents section on Sharepoint. Then set up a macro where I dump the data
from their workbook to the associated Lists, which will in turn update my
database. Is this possible? I know the users could go to the Lists directly
to update the data, but they will be sharing the workbook with other
workgroups and it would be easier if they could just post it on Sharepoint
rather than copy/paste the data into a List.

Any suggestions on the best way to get the data from an Excel workbook with
multiple tabs transferred to Sharepoint Lists?

Thanks!
Jim

 

[Jim]

Or is there a way to automate the import of all of the worksheets directly
from the Workbook on Sharepoint?