About how to use TXT, CSV table issues.

zhaozj2021-02-17  47

Steps: 1. Set the ODBC to generate the data source "Text Files" setting table where the Microsoft Text Driver (*. Txt; *.) Type is set. Such as: "C: / TXTDATEBASE" 2, set BDE to generate a "Microsoft Text Driver (*.) Alias ​​ODBC DSN set to the data source" Text Files "data sheet format generated by the first step : 1, generate a table structure description file: Schema.ini, the format is as follows: [MBStock] // Table name, this note is my plus, there is no colnamehead = true format = csvdelimited maxscanrows = 4 characterset = Oem Col1 = BJDM Char Width 16 Col2 = BJMC Char Width 20 COL3 = GH CHAR WIDTH 18 2 -76-135-Freaa B201301008, gear oil pump, CB-B25 B201301035, gear oil pump, CB-C25C-FL B2022020207H, oil mist, QIU-40

Schema.ini and MBStock are in the same directory. This allows the TXT table to be used in the program.

------------

转载请注明原文地址:https://www.9cbs.com/read-30535.html

New Post(0)