I am running SQL Server 2019 and MS Excel 2019 64-bit.  Is there a simple recipe I can follow in order to overcome the error:

The 'Microsoft.ACE.OLEDB.16.0' provider is not registered...

I don't have anything to add.  I just wanted to say thanks for your informative responses and articles.  I have shared some of your links with a coworker who is...

Thank you!  First I've heard of a Tally table.  I'm confused on one point in your discussion.  You say,

The largest number in the Tally table should not be just some...

Jeff Moden, you mention what you built previously.  Did I overlook a code sample or link?

Okay, how about this?  It doesn't use string_split().  I've tested it to 40,000 values several...

You can preserve order by creating a table with an identity column and then inserting values from string_split() into that table, like this:

Create Function [dbo].[fn_PreserveOrder]
(
 @InColumn varchar...