Power Query Isn’t Required: New Excel Functions Handle Straightforward Sources Cleanly

Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
TWCN Tech News

Convert CSV to Excel (XLS or XLSX) using Command line in Windows 11

Here is a tutorial to convert CSV to XLS or XLSX using the command-line interface in Windows 11/10. There are multiple ways to convert a CSV file to Excel formats (XLS, XLSX). You can use Microsoft ...
Ars Technica

T-SQL: Can't OPENDATASOURCE on an Excel file with a UNC path

I'm trying to connect to an Excel spreadsheet and populate it with data. Ideally, I'd like to be able to create the file on a remote machine. Here's the test SQL I ...