Solved

Export or FileCopy files from Access 2003 to Sharepoint Server

Posted on 2013-05-31
6
525 Views
Last Modified: 2013-08-15
Is it possible to transfer files from Acccess 2003 VBA that will either export or Filecopy a zipfile or datafiles from an Access 2003 mdb to a Sharepoint server.

First I would like to know if this is possible and I am looking for sample code.

the following will work on Windows 7, but not on an XP box.

Call FileCopy("R:\Access\Development\Gina\Automated\STA RSprositUpdate\DocumentsMissingStatus.xls", "http://collaboration.organon.intra/sites/GCORM_Business_Analysis/Sample BARP Process Site/SCBM STARS Test/DocumentsMissingStatus.xls")
__________________________________________________________

Part 2:

The file I need to save would be the daily run of agroup of files (.zip) that would include the current date.  As part of the validatation process I would like to validate the last file in the Sharepoint and retrieve all zip files from that date to present from the specified file location.  What would be the best approach to Look for the Max(Created Date) for the particular file name, and create a multifile upload process automatically.

Is there another workaround?

Thanks,

Karen
0
Comment
Question by:Karen Schaefer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39218602
Hi,

Try the code without the http in the destination like below.

Call FileCopy("R:\Access\Development\Gina\Automated\STA RSprositUpdate\DocumentsMissingStatus.xls", "//collaboration.organon.intra/sites/GCORM_Business_Analysis/Sample BARP Process Site/SCBM STARS Test/DocumentsMissingStatus.xls")

I don't understand Part 2.  Are you trying to copy from the R to SharePoint or from SharePoint.  Perhaps split this out to a separate question.

Regards,

Bill
0
 

Author Comment

by:Karen Schaefer
ID: 39219524
Thank you for for your input, however, removing the HTTP portion did not return an filecopy of the zip file uploaded to the Correct directory in SharePoint.

Disregard part 2.

I need to be able to Upload a zip file into SharePoint via VBA code, is it possible?  I am looking for code that will automate the Upload process from MS Access 2003 to a Sharepoint Location.

Karen
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39219612
Hi,

...the following will work on Windows 7, but not on an XP box.

Call FileCopy("R:\Access\Development\Gina\Automated\STA RSprositUpdate\DocumentsMissingStatus.xls", "http://collaboration.organon.intra/sites/GCORM_Business_Analysis/Sample BARP Process Site/SCBM STARS Test/DocumentsMissingStatus.xls")

If so then try removing the http and reversing the // like:

Call FileCopy("R:\Access\Development\Gina\Automated\STA RSprositUpdate\DocumentsMissingStatus.xls", "\\collaboration.organon.intra\sites\GCORM_Business_Analysis\Sample BARP Process Site\SCBM STARS Test\DocumentsMissingStatus.xls")

Regards,

Bill
0
 
LVL 14

Accepted Solution

by:
Bill Ross earned 500 total points
ID: 39219636
more...

If that does not work then you will need to determine the correct SharePoint virtual  "folder".

Contact your SharePoint admin.  

On our server the upload folder is:

\\servername\DavWWWRoot\Uploads  (which works fine in the above code)

The http equivalend is:

http://servername/Uploads/

Which does not work.

Regards,

Bill
0
 

Author Closing Comment

by:Karen Schaefer
ID: 39412019
Thanks.,
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question