can anyone tell me whats the best way to keep data updated with sharepoint without having direct link? i cant directly link my access 2007 with sharepoint, well i can but i better not. i can easly import data by "external data - import - sharepoint list" but the problem with this is that every time i import it creates a new table like tbl1,tbl2 and so on. although no information in this table gets updated from my side it does gets updated on sharepoint so i need new data in my table. i was thinking about making a query or something that renames a new table and deletes the old one but i was wondering if anyone knows any easier and simpler way