Join Date: Dec 2012
Importing CSV help
Ok so I'm simply trying to import this CSV file into a table within my database. I want a total of 2 columns. 1 being the type, and 2 being the code. I have looked at this file in notepad and excel and I don't know how to fix it. When I import it, I see the columns type & code, but all the information ends up in the one column 'type'.
Here is what shows in the table without information :Screenshot
Here is what the table looks like with the information: Screenshot
And here is the first few lines of code. There are 1600 lines of code total and they all are setup just like these. This is my first time using csv files so I'm sure I'm making a silly mistake. I just don't know what! Any help would be great.
This is what the file looks like within excel: Screenshot