I recently ran into an issue when creating a csv file from a MS SQL database and trying to load the data into an access db file.  The problem was there was an extra control character that cause the component to think there was one more column then there was. This might only be an issue with large column counts (mine is 140 columns).

In testing simply adding the header row to the sql SELECT statement solved the issue.

Example:

This failed.
INSERT INTO table1
SELECT * FROM  [Text;Database=C:\\tmp;HDR=YES].access.csv

This worked:
INSERT INTO table1
SELECT Column1, Column2,... Column140 FROM  [Text;Database=C:\\tmp;HDR=YES].access.csv

This could either be an option along side the include headers box or simply if the include headers box is checked do this.