Uploading Table to Sharepoint

[Kenny1943]

Hi

I've tried to do a search on this subject but the search engine is down.

Is there a way to use VBA in Access 2002 to upload a table/query to a sharepoint site. A database I'm running daily produces results from 2 queries that are exported to Excel then uploaded to sharepoint sites. This is done manually now. I would like to automate this.

Can someone help?

 

[EBGreen]

The way I handle this is to link the sharepoint list that you want ton update as a table. Then I run a delete query to clean the existing contents out and an append query to repopulate it.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[Kenny1943]

TomThumbKP-

That sounds interesting, but these 'spreadsheets' are added to the site and the last 10 days worth of reports are available for the users. So setting up a link won't do what I need.

Thanks for the input.