在ACCESS文件中创建一个查询
zz的SQL
SELECT a.*, *FROM [zz_361101#lst] AS a IN 'd:/myprj/cxyx'[text;]WHERE (((Left([khj],1))="3"));
在文本文件的同一目录下创建schema.ini文件,内容为
[zz_361101.lst]
ColNameHeader=False
Format=FixedLength
FixedFormat= RaggedEdge
MaxScanRows=25
CharacterSet=OEM
DateTimeFormat=yyyymmdd
Col1=khj Char Width 10
Col2=cq Char Width 9
Col3=zh Char Width 20
Col4=xm Char Width 9
Col5=khrq date Width 9
Col6=jyrq date Width 9
Col7=zhye currency Width 14
Col8=lxjs currency Width 16
Col9=xhrq char Width 9
Col10=zhzt short Width 1
zz的SQL
SELECT a.*, *FROM [zz_361101#lst] AS a IN 'd:/myprj/cxyx'[text;]WHERE (((Left([khj],1))="3"));
在文本文件的同一目录下创建schema.ini文件,内容为
[zz_361101.lst]
ColNameHeader=False
Format=FixedLength
FixedFormat= RaggedEdge
MaxScanRows=25
CharacterSet=OEM
DateTimeFormat=yyyymmdd
Col1=khj Char Width 10
Col2=cq Char Width 9
Col3=zh Char Width 20
Col4=xm Char Width 9
Col5=khrq date Width 9
Col6=jyrq date Width 9
Col7=zhye currency Width 14
Col8=lxjs currency Width 16
Col9=xhrq char Width 9
Col10=zhzt short Width 1