Thank you for your response; I'm not sure. My purpose for wanting to do this conversion is to automate data load from a .csv file into a SQL server database table Using Bulk Insert....

True! Not all web recommendations for solutions are safest.

Thank you.

Jeff, thank you for your questions - helpful 

I was able to load my data successfully using Bulk Insert. 
What I did:

1. I saved my file...

So, I saved my data file in notepad in ANSI format  and was able to load the data using Bulk Insert - however, when I load the data, only one...

One thing i did find in my data was that the bcp was reading a comma in my data as a terminator, although I had it in a double quote....

Thank  you for the information - I'm still having trouble loading the data into this table. I am soooo frustrated.
So, what I've done is begin with a fresh start:

At this point when I run my bcp script, I get the following in my error log file:

Invalid character value for cast specification @#
ÿþI                                                                                                                                                                                                                                                                                
#@ Row 3,...

11.0
69
1   SQLCHAR     0   12  "\t"  1  ID                         ""
2   SQLCHAR     0   0   "\t"  2  Submit_Date                      SQL_Latin1_General_CP1_CI_AS
3   SQLCHAR     0   0   "\t"  3  Email_Password                     SQL_Latin1_General_CP1_CI_AS
4   SQLCHAR    ...

wrong file content....

August 7, 2018 at 10:03 am

#2000649

I agree....
Below are the following - create table script to show my table structure, script I used to create my format file, and my bcp script to input the...

So I tried using BCP again with an error log added this is what I get: 

#@ Row 1, Column 4: Invalid character value for cast specification @#
ÿþS                                                                                                                                                                                                                                                                                

I shouldn't because the format file contains that information... Thanks.

What I have now done is to run the bulk insert script using a format file and with the...

So far it appears that the user has permissions on the files in the directory.

I am unfortunately still trying to load data in this table. This the current...