Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing a files properties (Access 2000)

    We are writing a program to import a whole series of documents into Access with attributes such as date created and modified. We can do this OK, but we also want to look at and import the other file attributes. These are the ones you see when you right click on the file, select properties and then look at the the summary and custom properties. Is it possible to extract this data so we can save it in the database as well?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Accessing a files properties (Access 2000)

    If you are talking about Word documents, you can use Automation to start Word, open the documents, and read their document properties, all in VBA code.

    Alternatively, you can download and install DSOFile.dll. See Dsofile.dll lets you edit Office document properties without Office in Visual Basic .NET 2003 and in Visual Basic .NET 2002. (It works in Office VBA too, despite the .NET reference)

  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing a files properties (Access 2000)

    Thanks, will look at both methods and see which works best.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •