create schema.ini dinamic…

Topic

New Reply

I use this schema.ini for a access table in Access.

Is possible to create the line column (in bold) dinamiclly based a reading in filed property and name?

Code:

Dim intFile, lngImported As Long, ULTIMA As Long
    
    On Error GoTo errore
    
    ULTIMA = Empty
    Close #intFile
    
    intFile = FreeFile(0)
    
    Open SPATH & "schema.ini" For Output As #intFile
    
    Print #intFile, "[" & NOME_FILE & "]"
    Print #intFile, "MaxScanRows=1"
    Print #intFile, "Format=Delimited(;)"
    Print #intFile, "ColNameHeader=TRUE"
           
    [b]Print #intFile, "Col1=""DATA_RIF""Text"
    Print #intFile, "Col2=""AGENZIA_CENTRO""Text"
    Print #intFile, "Col3=""SEGM""Text"
    Print #intFile, "Col4=""C_OPER""Text"
    Print #intFile, "Col5=""MS""Text"
    Print #intFile, "Col6=""MERC""Text"
    Print #intFile, "Col7=""TOT_OPE""double"
    Print #intFile, "Col8=""TOT_PEZ""double"
    Print #intFile, "Col9=""TOT_IMPORTO""double"[/b]    
    Close #intFile

Reply | Quote

Replies

See Creazione a livello di programmazione di un file schema.ini in Access 2000.

Reply | Quote

See Creazione a livello di programmazione di un file schema.ini in Access 2000.

Yes perefect! (you have understand me on fly) kiss for that.
But how to call the function and wath is the param to call the function?
And i can use this function in a vba for Excel macro?

Reply | Quote

Please see the explanation in the MSKB article and the example below the code.

Reply | Quote

Please see the explanation in the MSKB article and the example below the code.

pERFECT, TKS!
all work fine…

but is possible to insert a format in column when the code write the schema.ini?
For example the:

Print #intFile, Col2=AGENZIA_CENTRO Text format”#0000″

Reply | Quote

You can’t specify a format for individual columns in a Schema.ini file, as far as I know.

Reply | Quote

You can’t specify a format for individual columns in a Schema.ini file, as far as I know.

hummmm….
Now admit have myvar=tttt;555;65tttt;…eccc
how to have the same var string whit format #0000 on the second element of string
new myvar=tttt;0555;65tttt . …

Reply | Quote

You’ll have to format the value 555 as 0555 when you add it to myvar.

Reply | Quote

You’ll have to format the value 555 as 0555 when you add it to myvar.

yes…. I use this myvar to write in a txt file

Reply | Quote