Hello:
As I have been reading, In order to have ADO recordsets not read in the wrong data type, I need to create a schema file.
My frustration is, I have no idea how this file is referenced in my connection string / recordset. The articles re not clear on this.
I would like to be able to use this format for all files:
The FileName is MasterSchema.ini
Code:
[E7068911-Export.csv]
Format=CSVDelimited
Col1 = Level Text Width 20
Col2 = PN Text Width 15
Col3 = Desc Text Width 150
Col4 = Qty Double 3
Col5 = Rev Text Width 2
Col6 = RawMatl Double 3
Col7 = MatlQty Double 3
Col8 = MatlUnits Text Width 10
And my connection string code is here:
Code:
Dim cn As ADODB.Connection = New ADODB.Connection
Dim sql As String = "SELECT * FROM [" & CSVFILENAME & "]" ' ORDER BY 1" ' Cannot add this because of 1.1.10 issue
Dim rs As ADODB.Recordset = New ADODB.Recordset
cn.Open("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & CSVFULLFOLDERPATH & "; Extended Properties = ""text;HDR=Yes;FMT=CSVDelimited""; ")
rs.Open(sql, cn, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockReadOnly, CommandTypeEnum.adCmdText)
Do I need a filename to match every filename in the ini file? Where is this referenced in my code so that it gets used.