lists to tables

[Glassblade]

I'm aware that this is probably a silly question but is there a way of
pulling sharepoint lists back as access 2007 local tables - I've got a
client who needs to change hosting etc. and do a little development
before linking back to sharepoint. However the database turns out to
be undocumented and a little idiosyncratic. Can anyone suggest a
simple global way of getting the app to function as a conventional
access database?

thanks

Pete