auto create table from excel
i have file excel multi column about 100 column.
I suggest feature, when i open excel, auto create struct insert table.
2
votes
Lập trình VB
shared this idea
-
Adam Eagle commented
Not sure if this is permission restricted, but in SSMS, Right Click on the database and select 'Import Flat File'. Pretty sure that gets what you're looking for.
With 100 fields, SSMS might run a bit slow, so you might want to use Azure Data Studio for that instead, but, essentially, this feature is native to SSMS/ADS.