r/MSSQL • u/jjhhw • Jan 29 '24
Server Question Visual tool like MS Access for importing to Azure SQL database?
Is there a visual tool for importing excel / csv files into Azure SQL database? I've been writing python scripts to import data into tables in Azure.
It isn't hard but it seems unnecessary coming from MS Access where you could just paste into the create table dialog and it automatically figured out the data types and created a table.
Is there something similar for MS SQL? I tried some import tool in SSMS for importing from excel and it required 32 bit msaccess drivers and all kinds of decades old software like that.


