Hello,

I have a table that I need to export daily to excel to manipulate some data,
and then import this back into my SQL table. What I need to happen is that I
need the export and import to both override existing data. Meaning that when
I export to excel, it exports to my data sheet and replaces all data there,
and when I import back into my SQL table, it will replace all data there.

It seems that I need to adjust some settings in the import part where it
asks me about transformation, but I do not know how. Can anyone help?

Thanks much,