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

Colin Riddington 141 Reputation points MVP
2024-05-29T20:09:23.51+00:00

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/event/access-europe-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 AccessUserGroups.org web page for this event.

As always, the session will be recorded and the video uploaded to YouTube after the event

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,205 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
848 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Colin Riddington 141 Reputation points MVP
    2024-06-04T14:16:23.4066667+00:00

    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.

    0 comments
  2. Colin Riddington 141 Reputation points MVP
    2024-06-07T17:18:58.41+00:00

    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/

    0 comments