ExtendedProperties, The Microsoft Jet OLE DB 4.0-compatible extended properties for text. All I have to do is change the numeric to non-numeric for that field only and it works fine!! e.g CDTExpiry,1 to CDTExpiry,a.Īnyone know why this would be happening, as I am using this code for a bulk load of data from the csv file, and I don't want to always check the file first for this line of Code. Data Formatting FMT, The format to be used to parse all text files. OleDbDataAdapter dAdapter = new OleDbDataAdapter(query, connString) įor some reason the CDTExpiry field is giving an issue. create an OleDbDataAdapter to execute the query create a DataTable to hold the query results This is a 'first time' read issue with Unicode. Never had the problem reading the file before but have avoided working with Unicode. + "Extended Properties=\"text HDR=Yes FMT=Delimited\"" '.4.0 Data Source' & App.Path & ' Extended Properties''Text HDRYES IMEX CharacterSetUnicode''' I should mention that the requirements are VB6 for a NON. create the "database" connection string String dir = Path.GetDirectoryName(full) ![]() ![]() Public static DataTable ParseCSV(string path) I am using the following code to read the file: using System ![]() Here are the file contents: **ColumnName, Column Value**
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |