General information
Category:
Database DAO/RDO/ODBC/ADO
Is my memory foggy here Karriem or do you not also have to create a schema file when using this technique? If I remember this file must be included in the same directory as the import file. I've used it before as well and I think you have to lay out the schema.ini file as something like:
[Gscdata.txt]
ColNameHeader=False
Format=FixedLength
MaxScanRows=25
CharacterSet=ANSI
Col1=Internal_ID Char Width 10
Col2=Residence_Code Char Width 7
Col3=Admission_Number Char Width 15
Col4=Pat_Chart_Loc Char Width 10
Col5=Inst_Type Char Width 1
Col6=Pat_Name Char Width 40
Col7=UnitChart_Number Char Width 10
Col8=Admit_Date Char Width 10
Col9=Admit_Time Char Width 5
Col10=Disch_Date Char Width 10
Col11=Disch_Time Char Width 5
Col12=Period_Number Char Width 2
Col13=Facility Char Width 6
Col14=Disch_User_Code Char Width 6
Col15=Province Char Width 5
Col16=Postal_Code Char Width 7
Col17=Sex Char Width 1
Col18=Resp_For_Payment Char Width 1
Col19=Loc_Trans_From Char Width 6
Col20=Ambu_Type Char Width 1
Col21=Loc_Trans_To Char Width 6
Col22=Birthdate Char Width 10
Col23=HCN Char Width 18
Col24=Weight Char Width 6
Col25=Disch_Status Char Width 1
Col26=Deceased_48h Char Width 3
Col27=Marital_Status Char Width 1
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only