Results 1 to 2 of 2
  1. #1
    NycNessyness is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    1

    Extract .xml files from a Folder and place within Attachment column

    Hello Everyone! Before asking my question, I first want to say I don't have any concrete programming knowledge. I'm working with a sharepoint site and have a document library where our infopath forms are stored in the Forms folder. The problem is that when I export the list to access, the field, which should be an attachment field shows all the files as links to the forms folder because they weren't saved as attachments. I have a simple program that is able to do what I want if the attachment is imbedded in a list but it does not work the same way if it is within a document library, without an attachment column.

    What I would like to do, if anyone knows, is run a program that can look in a folder, for example a folder called "ExtractedxmlFiles" and search by the "Name" property of the files and see if it matches the "Name" property in the Access file, that has the list imported. If it does, then it will add it to the attachment field for that row. Any help is appreciated. Thanks!

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    search for "vba file properties"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Number of files in a folder.
    By Iain in forum Reports
    Replies: 3
    Last Post: 06-17-2012, 01:53 PM
  2. How I Exported an Attachment fields data to a folder
    By ChuckColeman1812 in forum Import/Export Data
    Replies: 1
    Last Post: 06-13-2012, 08:51 PM
  3. Replies: 13
    Last Post: 05-23-2012, 12:30 AM
  4. Copy files into specific folder
    By Jan22 in forum Access
    Replies: 12
    Last Post: 04-17-2012, 08:27 AM
  5. Extract file attachment from email to Access
    By bet in forum Import/Export Data
    Replies: 3
    Last Post: 02-02-2011, 07:35 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums