You can also use BULK INSERT for csvs or just INSERT INTO and some text editing depending on the specifics.
This is more for one-off stuff like analyzing some 10,000 row spreadsheet you’ve been handed that you could probably do with formulas in excel, but it’s easier to use sql, but not worth building a proper process for.
You can also use BULK INSERT for csvs or just INSERT INTO and some text editing depending on the specifics.
This is more for one-off stuff like analyzing some 10,000 row spreadsheet you’ve been handed that you could probably do with formulas in excel, but it’s easier to use sql, but not worth building a proper process for.