Note to my future self:
- In the Excel, Find/Replace “NULL” values with blanks
- Select all columns and convert to Text
- If file is less than 65,000 rows, save as .xls
- If replacing old SQL Table: In SQL, right-click on old table and use View Dependencies to see where table is referenced.
- If replacing old table, right-click on old table and use Create To to make sure data types and properties match between the old and new tables.
- Right click on database, under Tasks select Import Data to open Import Wizard.
- Select Excel File
- Enter Server Name, Username, Password, and Database.
- Copy data from table
- Select Source and Destination
- Review Data Type Mapping
- Complete the Wizard.
- Cross your fingers and hope for success.