Export access table to Sharepoint as an Excell table

E

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?
 
T

tina

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

hth
 
E

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...
 
Top