On Mon, Sep 29, 2014 at 04:54:48PM +0100, Mark Rogers wrote:
On 29 September 2014 14:25, Chris Green cl@isbd.net wrote:
'2014-09-29 15:05', 22.125, 22.75, 13.6285714286, 13.8876923077, 34.36875,
0.253125, 14.85, 8.803125, 8
Silly question, but since this is just CSV data, why not stick with it but put a header line above it listing the fields?
Not a silly question at all, I could very easily do as you say and it seems at first glance to be a good solution.
Is there any easy *programmatic* way to do an SQL insert from a CSV with headings?