Why is the column name from the CSV file different from its DataTable?

Question

I use OleDbConnection, OleDbCommand and OleDbDataReader to read a CSV file in a DataTable.

The CSV file uses the first line as the header line.

Some names in the header have non-alphanumeric characters, such as (_. /).

When the system creates column names, it carries over. (period) to symbol # (pound sign).

Why is this one character changed and is there a way to stop the change by creating. (period) of being in a column name?

Thanks,
Whale

Answer 1

It replaces periods because they are metacharacters in SQL for specifying hierarchies. I do not think that it is generally advisable to try to save the period.