Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasks

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • isladogs
    Recognized Expert Moderator Contributor
    • Jul 2007
    • 479

    Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasks

    The next Access Europe meeting will be on Wednesday 5 June 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by about 19:30 (7.30PM)
    The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST
    Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy

    In this month's session, I will be demonstrating two free applications:

    Extended File Properties
    There are currently over 320 extended file properties, though no files will ever contain all of those.
    This app provides an easy way of obtaining and storing all the extended properties for an individual file or all files in a selected folder and its subfolders.
    This has many possible uses including cataloguing large number of photos or music files and identifying duplicates

    Manage Import / Export (IMEX) Data Tasks
    Prior to Access 2007, import/export (IMEX) specifications were always saved in 2 system tables: MSysIMEXSpecs / MSysIMEXColumns .
    These were only available for text files e.g. CSV.
    This approach is still available but was supplemented with a wizard driven XML based system of Import/Export Data Tasks in Access 2007.
    The new approach is very simple to use and works for a wider range of files including Excel spreadsheets, Access tables, XML, HTML as well as text files.
    However, ease of use has also led to much greater obscurity in how the newer approach works.
    This app was created to allow users to view and easily edit the contents of Import/Export Data Tasks and make them a much more useful feature

    For more details about this session, see: https://accessusergroups.org/europe/...pe-2024-06-05/ or https://isladogs.co.uk/aeu-28/


    The meeting will again be held on Zoom. When the time comes, you can connect using: Join Zoom Meeting.
    If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210

    For more connection options, please see the AccessUserGroup s.org web page for this event

    As always, the session will be recorded and the video uploaded to YouTube after the event
  • isladogs
    Recognized Expert Moderator Contributor
    • Jul 2007
    • 479

    #2
    REMINDER

    The next Access Europe Meeting is tomorrow (WED 5 June) starting at 18:00 UK time (UTC+1).
    For details of the meeting and connection info, see post #1 above.

    Please download and import this iCalendar (.ics) file to your calendar application e.g. Outlook.
    Doing this will add a recurring event for the first Wed of each month at the correct time for your location/time zone.

    Comment

    • isladogs
      Recognized Expert Moderator Contributor
      • Jul 2007
      • 479

      #3
      The video of my presentation to Access Europe on Wed 5 June is now available on YouTube: https://www.youtube.com/watch?v=jUed-4aCUxs
      Hope others find it useful
      There were two separate parts to the session.
      A PDF of each presentation together with the two example databases used in the session are available from https://www.isladogs.co.uk/aeu-28/

      Comment

      Working...