Importing CSV data to an existing table

Importing CSV data to an existing table

Hi,

Really like the DB facility. I've tried to import csv data to an existing table and have the data added to the end of the table as new rows without success. I've tried both the paste and local file import methods. The data is standard csv with a comma separator. If I import the data into new columns this works fine. If I import into the existing columns it fails to start and gives no error message to indicate where the problem is.

Any help you can give would be great - I've worked around the problem by consolidating the data in a spreadsheet and importing as a new table - but losing the features of lookup columns etc in the process.

Cheers
David