Import External Data doesn't import

Actually I've just realised that my import doesn't include the headers for the date columns, presumably because they are text rather than dates. It might be best to name the data area (including the second row of headers) ie row 7 downwards in your source file and set the query to import the named range. This imports the data and headers correctly. You can add the first row of headers and any other rows above the query.