sqlBulk.ColumnMappings.Add(new SqlBulkCopyColumnMapping("[W.C.V]", "WCV"));
i'm importing excel data into sql database, a column in the excel file has special characters (W.C.V) I cannot get the code to accept the special characters; I've tried "IMEX=1" in connection string without success.
It is difficult to change the column in the excel, as it comes from a client.
Maybe this will help, http://stackoverflow.com/questions/823511/problem-in-reading-excel-sheet-with-special-character-in-c-sharp
"Googling around suggests that this is an inherent feature of OLEDB, rather than being anything to do with Excel - it seems to simply not like periods (.) in column names."
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.