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

Question

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

Answer 1

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.

Answer 2

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/