ET: Working with Excel Data in Access Applications

Leverage data stored in Excel in your Access applications.
Host Dale Fye demonstrates and explains several ways to enhance your Access applications with data stored externally in Excel files.

Dale demonstrates and explains:

Tools to select an attach Excel files in your Access application.
Link to an already open Excel file to obtain data.
Validate data in an Excel file for use in your Access application.

A highlight of the presentation is a technique to make Excel data read/write from within Access, using queries with this pattern.
SELECT XL.*
FROM (
SELECT * FROM [Sheetname$] as xlData
IN 'filepath\filename.xslx'
[Excel 12.0;HDR=yes,IMEX=0,ACCDB=Yes]) AS XL;

In the video, Dale reveals the reason this method works to link external External Excel files as Read/Write in your Access application.
===================================================
Note: The presenter lost audio near the end of the session. The missing portion of his presentation will be included in the next session on March 18th.