Posting this just in case I lose my file but I created a CFM page that scripts data for quick insert statements. I know there are good SQL Server Management tools that does this but I wanted something that didn't require trial versions or paid versions.

This assumes your primary key is called "id" but you can change it to be whatever and will output a txt file to a location of your desire.