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.
BARP Process Site/SCBM STARS Test/DocumentsMissingStatu
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?