Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Improving speed to Import a text file into Access DB AD
Message
De
09/01/2002 12:49:10
Jason Dalio
Northern Interior Regional Health Board
Prince George, Colombie Britannique, Canada
 
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00601606
Message ID:
00602590
Vues:
22
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform