Export access table to Sharepoint as an Excell table

[Ernie]

My client users only use Excel so I'd like to be able to export an Access
Query to Sharepoint as an Excel table. Is there a way to do this?

 

[tina]

take a look at the TransferSpreadsheet Method and OutputTo Method topics in
VBA Help, and also their companion Action topics.

hth

 

[Ernie]

Hmmm, since I don't know visual basic (yeah, I'm a rookie), I think the
easiest way might be to just export the access table to excel them post it on
the Sharepoint site. One more step to take but simple to do...