> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# clsImExSpecs Presentation to the Access Europe User Group
- URL: https://nolongerset.com/imex/
- Published: 2023-12-06T17:35:28.000Z
- Updated: 2026-05-08T12:38:26.000Z
- Description: A list of resources and further reading for my presentation on my custom Import/Export Specifications class module.
- Author: Mike Wolfe
- Tags: Presentations, #Import 2026-05-20 02:59

## Slide Deck

[clsImExSpecs.pdf](https://assets.nolongerset.com/2023/clsImExSpecs.pdf)

## Sample Files

*The following files were used during the presentation:*

- [SaleData.txt](https://assets.nolongerset.com/2023/SaleData.txt)
- [Sale.xml](https://assets.nolongerset.com/2023/Sale.xml)
- [ErrorMod\_Minimal.bas](https://assets.nolongerset.com/2023/ErrorMod%5FMinimal.bas)
- [clsImExSpecs.cls](https://assets.nolongerset.com/2023/clsImExSpecs.cls)
- Sample Database: [ImExPresentation.zip](https://assets.nolongerset.com/2023/ImExPresentation.zip)

Note that the sample database above was *created live during the presentation*. It includes the full **clsImExSpecs** class module, the minimal ErrorMod error-handling module, and a **Sale** table that represents the imported Sale.xml data from above.

## Presentation Recording

The [presentation recording](https://www.youtube.com/watch?v=VUEMv%5F05hws) is available on YouTube on the Access User Groups [YouTube Channel](https://www.youtube.com/@AccessUserGroups/videos).

## Further Reading

[Creating and Editing Import Specifications via the WizardFor one-off text file data imports, it’s hard to beat the simplicity of Microsoft Access’s built-in wizard.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/11/Import-Text-File-Data-with-Ease.jpeg)](https://nolongerset.com/import-specs-via-the-wizard/)

[Using the Wizard to Export to Text Files with Microsoft AccessIn an effort to remain simple, the Access export to text file wizard manages to do the opposite, making simple updates to export specs unnecessarily cumbersome.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/12/Export-Text-File-Data-with-Access-Wizard.jpeg)](https://nolongerset.com/export-specs-via-the-wizard/)

[Documenting the Import-Export Specification System TablesDocumentation of the meaning and typical values that get saved to the Import-Export specification system tables: MSysIMEXSpecs and MSysIMEXColumns.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/11/ImEx-Tables.jpg)](https://nolongerset.com/imex-spec-tables/)

## Referenced Links

Here are some links to articles that came up during the presentation or were included in the chat:

[Dark Mode in VBAVBA may not have a preset “Dark Mode” like other modern development environments, but it’s not hard to create one yourself.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/Dark-Mode-in-VBA.jpeg)](https://nolongerset.com/dark-mode-in-vba/)

[“Toggle” Hotkey for the Immediate WindowAm I the only one who finds it annoying that \[Ctl\] + \[G\] doesn’t \*toggle\* between the immediate window and the code window? Let’s fix that.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/Autohotkey_Twitter_Logo-2.png)](https://nolongerset.com/toggle-hotkey-for-the-immediate-window/)

[Everything You Need to Find FilesOr, should I say, You Need \*Everything\* to Find Files.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/02/2021-02-12-15_05_26-GBM18-Window.png)](https://nolongerset.com/everything-you-need-to-find-files/)

[Use XML to Share Access Table Data and Avoid Internet WarningsAnti-virus software and Microsoft policies make it harder than ever to share table data among Access users. The XML format is a simple way to avoid those roadblocks.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/12/XML-Sharing.jpg)](https://nolongerset.com/share-xml/#importing-xml-step-by-step)

[Better Global Constants in VBA with Dot-Driven DevelopmentMy global constant “C” class--with PredeclaredId = True--is a great alternative to traditionally-declared global Public Const’s.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/03/better-global-constants.jpeg)](https://nolongerset.com/better-global-constants/)

[Enum Type Naming ConventionThe combination of “IntelliSense overload” and “global identifier case changes” convinced me I needed a different approach.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/10/scrabble-15546_1920.jpg)](https://nolongerset.com/enum-type-naming-convention/)

## 

## Past Presentations

If you enjoyed this presentation, you may want to check out some of my past presentations. Each of these has accompanying videos of the presentation available on YouTube (links to YouTube included in articles below):

[Form Templates Presentation to the Denver Area Access User GroupA list of resources and further reading for my presentation on Form Templates in Microsoft Access.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/06/PowerPoint----Form-Templates.png)](https://nolongerset.com/daaug-form-templates/)

[Advanced Combo Box TechniquesA list of resources and further reading to support my presentation on Advanced Combo Box Techniques.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/06/AdvancedComboBoxTechniques.jpg)](https://nolongerset.com/combo/)

[ArrowKeyNav PresentationA list of resources and further reading to support my presentation on Navigating Continuous Forms using WithEvents.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/ArrowKeyNav-Talk.png)](https://nolongerset.com/arrowkeynav/)

[Troubleshooting Query PerformanceA recording of the presentation, a list of resources, and further reading for my presentation on Troubleshooting Query Performance.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/PowerPoint-Slide-Show-----Troubleshooting-Query-Performance.jpg)](https://nolongerset.com/troubleshooting-query-performance/)

[Defensive Programming - DevCon 2023Links and resources from my talk tomorrow at Access DevCon Vienna 2023, Some Bugs are Better than Others: Defensive Programming Tips and Tricks.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/04/2023-04-27-02_02_32-mjw20-DefensiveProgramming-DevCon2023.pptx---PowerPoint.png)](https://nolongerset.com/devcon-2023-bugs/)

[Understanding COM - DevCon 2022Links and resources from my talk today at Access DevCon Vienna 2022, Understanding COM.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/understanding-com.jpg)](https://nolongerset.com/understanding-com/)

[Building Ribbons in CodeA list of resources and further reading to go with my Access User Group presentation on Building Ribbon Interfaces in Code.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/07/2022-07-06-00_48_59-mjw20-PowerPoint-Slide-Show-----Building-Ribbons-in-Code.pptx.png)](https://nolongerset.com/ribbon/)

[DevCon 2021Links and resources from my talk today at Access DevCon Vienna 2021, twinBASIC: The New Kid on the Block.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/04/2021-04-20-17_18_00-GBM18-TwinBasic-DevCon2021.pptx---PowerPoint.png)](https://nolongerset.com/devcon-2021/)

[twinBASIC Update - DevCon 2022Links and resources from my talk today at Access DevCon Vienna 2022, twinBASIC: Happy First Birthday!![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/TwinBasic-DevCon2022.png)](https://nolongerset.com/devcon-2022/)

[twinBASIC Update: DevCon 2023Links and resources from my talk today at Access DevCon Vienna 2023, twinBASIC + Access: Future Plans.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/04/2023-04-27-08_30_55-GBM18-TwinBasic-DevCon2023.pptx---PowerPoint-1.png)](https://nolongerset.com/devcon-2023-tb/)

***UPDATE*** *\[2024-02-02\]: Added link to presentation recording on YouTube.*