使用ADODB将csv文件作为记录集打开时的空备忘录字段(Null memo fields when opening a csv file as a recordset using ADODB)

 我非常坚持这一点，不知道如何继续。 我正在使用ADODB打开CSV文件，这是正常工作但是我的CSV文件中存在的文本字段被打开为空字段，所有数字字段都正确设置。 
 
 我这样打开CSV文件; 
 
Set adoOpen = Server.CreateObject("ADODB.Connection")
adoOpen.ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:/;Extensions=asc,csv,tab,txt;HDR=NO;Persist Security Info=False"
adoOpen.Open
Set rsOpenRS = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM `Import.csv`"
rsOpenRS.Open sSQL, adoCon
 
 我还有一个schema.ini文件设置，它告诉我如何打开我的字段，就像这样 
 
[Import.csv]
ColNameHeader=True
Format=CSVDelimited
Col1=MyTextField Memo 
Col2=MyNumberField Double
Col3=MyOtherNumberField Double
 
 我的CSV文件中的数据如下所示 
 
MyTextField,MyNumberField,MyOtherNumberField
"Some text here",1,100
 
 当我遍历我的字段时，我希望看到以下内容 
 
MyTextField = Some text here
MyNumberField = 1
MyNumberField = 100
 
 但相反，我得到的是这个 
 
MyTextField = 
MyNumberField = 1
MyNumberField = 100
 
 它只是忽略该字段中的文本，但文本肯定存在于CVS文件中。 
 
 我尝试使用Text而不是Memo，这可行，但它只带回前255个字符，而且我的一些字段有更多，所以它们被截断了。 
 
 我希望有人可以帮助我。 
 
 干杯 

I'm pretty stuck with this and don't know how to proceed. I am using ADODB to open a CSV file, this is working correctly however my text fields that exist in the CSV file are being opened as null fields, all of the number fields are correctly being set.
 
I open the CSV file like so;
 
Set adoOpen = Server.CreateObject("ADODB.Connection")
adoOpen.ConnectionString = "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=C:/;Extensions=asc,csv,tab,txt;HDR=NO;Persist Security Info=False"
adoOpen.Open
Set rsOpenRS = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM `Import.csv`"
rsOpenRS.Open sSQL, adoCon
 
I also have a schema.ini file set up which tells it how I want my fields to be opened, like so
 
[Import.csv]
ColNameHeader=True
Format=CSVDelimited
Col1=MyTextField Memo 
Col2=MyNumberField Double
Col3=MyOtherNumberField Double
 
My data in my CSV file looks like this
 
MyTextField,MyNumberField,MyOtherNumberField
"Some text here",1,100
 
When I loop through my fields I would expect to see the following
 
MyTextField = Some text here
MyNumberField = 1
MyNumberField = 100
 
But instead what I get is this
 
MyTextField = 
MyNumberField = 1
MyNumberField = 100
 
It just ignores the text that is in that field, but the text is definitely there in the CVS file to start with.
 
I have tried using Text instead of Memo, this works, however it only brings back the first 255 characters, and some of my fields have more than this so they are getting truncated.
 
I hope somebody can help me out.
 
Cheers

原文：https://stackoverflow.com/questions/29624757