SOLVED

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

MVP

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

 

CoverSlide.PNG

 

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 MeetingIf 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

2 Replies

REMINDER
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.

best response confirmed by isladogs (MVP)
Solution

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/

1 best response

Accepted Solutions
best response confirmed by isladogs (MVP)
Solution

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/

View solution in original post