Ok, just thought with the detail I gave was enough to understand the issue at hand. I didn't think that posting SQL statements for tables and data would really...

Figured it out.

to theSQLGuru:

The reason I have a view was because my original data the juliandate and listcode are one field so the view splits the two out. There is nothing special...

Never mind I figured it out. I changed it to an Outer Join for the records. Completely forgot to do that!

I think you need to change your ROWTERMINATOR to quotes or something like that.

I figured it out. I had to create a view of the database and use it like this:

CREATE VIEW v_names as

SELECT [File], [First Name], [Last...

That didnt work either.

Well I just changed the column lengths to max on the database side and it imported. I looked at the data and every column was shifted left one column....

Yea I created the table that you wrote up. I will work on it. I might just try and make them max, which I was trying to get...

Expanded the state and year column as well still same error.

I have created the 2nd table and tried inserting the data into it, I receive the same error. As for the Zip column, our zip information is actually two...

Ok thanks again!

Alright, that worked. How did you get the code for the sample data or did you just type that all up? Also, is there something simple to show...

Also, to get the numbers I posted as a result from my query I would have to post data with 100k rows.

Sorry yes I tried your query you created and it did not work. Gave me three errors on three different lines:

Msg 156, Level 15, State 1, Line 2

Incorrect syntax...