I have used this tool a few times and honestly, its a lot quicker than the “Import and Export Data” tool or the “Generate Scripts” option under Tasks. This is a tool built by Perceptus Consulting to import data from Excel into an existing SQL table quickly. It just gives you the import script and you can modify it as you like. You can modify the script to make the transaction explicit, or simple add more statements to the script. It’s simple and a lot safer than running unreliable wizards.
Here is the tool: