How to Convert .txt and csv Files to SQL Tables in Azure Data Studio | Use of Sql Server Import Ext

The SQL Server Import extension converts .txt and .csv files into a SQL table. This wizard utilizes a Microsoft Research framework known as Program Synthesis using Examples (PROSE) to intelligently parse the file with minimal user input. It's a powerful framework for data wrangling, and it's the same technology that powers Flash Fill-in Microsoft Excel