3 ms·
> If you’re deep in the Excel world, chances are extremely high that you also have access to SSMS, Can you provide more information about this? Like, I'd rein
by disgruntledphd2 2y ago
> If you’re deep in the Excel world, chances are extremely high that you also have access to SSMS,
Can you provide more information about this?
Like, I'd reinstall windows if this would actually work on messy excel/CSV data.
- Kon-Peki 2y agoThere is a screenshot here [1]. The trick is to choose the generic "import data" task rather than "import flat file". Then you have a wizard that lets you play around with the specifications, change things up, look at the errors, go back to tweak things, go forwards to try again, etc. The only improvement I can think of is if you could save what you did as a standalone SSIS package (or whatever). [1] https://www.mssqltips.com/sqlservertutorial/9248/import-and-export-data-with-sql-server-management-studio/ https://www.mssqltips.com/sqlservertutorial/9248/import-and-...