You could do it simpler by creating a temp table with all columns in the CSV and then doing either creating another table of the temp table or building a view on top of the table.
The decision depends on how frequently you would be importing data from the CSV. If only one time then you are better off doing it through a spreadsheet. Thanks Rajeev On October 27, 2015 4:49:22 AM GMT+05:30, David Blomstrom <david.blomst...@gmail.com> wrote: >Wow, I must be getting dyxlexic; yes, it is > >\r\n > >I guess it would be easy enough to just copy the stuff I want to import >into a separate spreadsheet and save it as a CSV. I've done that before >with really big spreadsheets, actually. Thanks. -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
