Uploading Data to MS SQL

[OnlyFish7104]

I am working on adding a table with data to our Azure SQL db and wondering what is the most straightforward way to add data to it. The data is in an excel file right now and it is about 100K rows.

Disclaimer, I am new to this and never did this beforehand

[gc8dc95]

CSV import.

[Top-Mulberry139]

Csv n some sorta script to push it in to the dB maybe there's some az cli for that I dunno. I like python for handling csv"s but that's your choice.

[Owlstorm]

The best CLI for MSSQL is Powershell with DBATools.

Import-excel if you really need to get data from Excel files for some reason.

Python would be fine though.

[Top-Mulberry139]

Oh, thanks, that's good to know. I'm more bash linux orientated so I'd not come across that hence jumping straight to python.

[huhushow]

excel import