CSV files only import one column

[Chirag101]

I am importing a csv file from SP connector, and it only loads the header of the first column and the data of the last column (sample below.). The file contains from 10 columns in total.

Checked the file in notepad if the delimiters are commas and see no issues there.  I'd really appreciate your guidance.

Header Column# 1

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

Data Column# 10

[bighead]

@Chirag101 Have you tried increasing the field length?

[Chirag101]

I increased it to 1,073,741,823, the max size but no avail.