Copy local file to a sharepoint Folder?

[Number11]

Hello,

I need to copy a report that is generated from MS Access from c:\ drive to a sharepoint folder is this possible

 

[The_Doc_Man]

I would start by doing a DoCmd.OutputTo of the report to a specified local file. Then you perhaps could use FSO to copy the file.

File Management with Scripting Object | Database Journal

Managing files should be really simple in Access, but it's not. Well, once you get familiar with the File Scripting Object (FSO), it's not so bad, but

www.databasejournal.com

The video is done from Excel but uses VBA to do it so the basic code would work from Access's VBA.

Finally, when finished with the copy operation, dispose of the local copy with the VBA "Kill" verb.

 

[Number11]

thanks so i have my excel report created in a local found so just need to now have the code coy the file to a sharepoint folder

 

[Gasman]

W

thanks so i have my excel report created in a local found so just need to now have the code coy the file to a sharepoint folder

Why not watch the video and just do it directly?