How can I make sure that a table and csv file can merge in an azure databricks query

I am currently trying to copy data from a csv file into my table in azure databricks and am getting the following error.

[DELTA FAILED TO MERGE FIELDS] Failed to merge fields ‘transfer_month’ and ‘transfer_month’

I am unable to solve the error. I can confirm that the number, order and name of columns are matching so I’m guessing it’s something to do with the data type.

my query is formatted as shown below

CREATE TABLE catalogB.schemaB.tableB(
  transfer_month    STRING,
  value             DOUBLE
);



COPY INTO catalogB.schemaB.tables
FROM '/Volumes/catalogA/schemaA/data.csv'
FILEFORMAT = CSV
FORMAT_OPTIONS(
  ‘header’ = ‘true’,
  ‘ignoreCorruptFiles’ = ‘true’
);