Export access table to Sharepoint as an Excell table

  • Thread starter Thread starter Ernie
  • Start date Start date
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?
 
take a look at the TransferSpreadsheet Method and OutputTo Method topics in
VBA Help, and also their companion Action topics.

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