Update to my last: a batch process could work like this, using code from Noman and adding some bits

-- Create the target table (Products), which contains the...

Thanks for an interesting read and inspiration to do more research. Unfortunately, in the batch processing code there seem to be some bugs.

Using the SOURCE definition as a subquery (SELECT...

And maybe for the task on hand the code 12 would be correct for ISO "yymmdd" format:

DECLARE @YYMMDD DATETIME
SET @YYMMDD='2020-09-23 00:00:00.000' /* converts literal string to DATETIME...

Adding to the questions rather than the solutions:
Reading the caveats on the Access Database Engine install (link in Lowell's post above): it is NOT supposed to replace the JET...

Thanks for this tutorial, it was very helpful for my ETL project. I put instances of the task in at various places, it did work great. Now finally, I get...