I exported results from a query in order to import it into a table on another DB. I chose the xlsx output format and verified that the data had gotten written to the excel file. While trying to import it into the table, I chose to create an insert script so that I could go over the final data before importing it. On doing this, I noticed that all the varchar fields have a N character right before the opening quote, making it look like:
INSERT INTO ... ()
VALUES(N'...', 0.0, N'....')
Any ideas on why this might be happening and how I can avoid it?