Is there any chance of being able to download the datafeed as an sql file rather than csv?
thanks
uhh you tried convering the csv to sql? i gave up after a very long while. always seemed to be something wrong with one row or something.
and sql is just easier to work with.
when I need to add a csv to a db table, i open it up in excel first, highlight all the text rows, find all quotes and commas and replace with nothing.
Save, zip and upload.
Only takes 2 ticks.
You can even move fields around if your DB isnt set up exactly as the AffWin DB