Best is to use Excel as the export, import format.
Sometimes you need to change the design of the table(remove primary key, disable read-only, etc), to make it work.
select db, choose Tasks->export data, choose excel.
to restore, choose Tasks -> import data,
select the file and make sure the mappings are correct.