Sie sind aktuell nicht angemeldet.

Funktionen: Einloggen  |  Neu registrieren  |  Suchen

Fortsetzung
Autor: SL
Datum: 23.09.03 12:58
Specifying Data Type Formats and Conversions The Schema.ini file contains a number of entries that you can use to specify how data is converted or displayed when Microsoft Access reads it. The following table describes each of these entries. Entry Description DateTimeFormat A format string that specifies the format for dates and times. You should specify this entry if all Date/Time fields have the same format. You can use any Date/Time format except A.M. and P.M. display formats. DecimalSymbol Specifies the character used to separate the integer from the fractional portion of a number. NumberDigits Specifies the number of decimal digits in the fractional portion of a number. NumberLeadingZeros Specifies whether a decimal value less than 1 and greater than –1 should contain leading zeros; you can set this entry to False (no leading zeros) or True. CurrencySymbol Specifies the currency symbol used for currency values in the text file; for example, the dollar sign ($) or Dm. CurrencyPosFormat Specifies the position of the currency symbol. You can set it to any of the following values: 0123 Currency symbol prefix with no separation ($1) Currency symbol suffix with no separation (1$)Currency symbol prefix with one character separation ($ 1)Currency symbol suffix with one character separation (1 $) CurrencyDigits Specifies the number of digits used for the fractional portion of a currency value. CurrencyNegFormat Specifies the format of negative currency values. You can set it to any of the following numbers: 0 ($1) 1 –$1 2 $–1 3 $1– 4 (1$) 5 –1$ 6 1–$ 7 1$– 8 –1 $ 9 –$ 1 10 1 $– 11 $ 1– 12 $ –1 13 1– $ 14 ($ 1) 15 (1 $) The dollar sign ($) is shown only as an example; you should replace it with the appropriate currency symbol. CurrencyThousandSymbol Specifies the character used to separate thousands in currency values. CurrencyDecimalSymbol Specifies the character used to separate the whole from the fractional portion of a currency value. Note If you omit an entry, Microsoft Access uses the default value in Windows Control Panel. Example of a Schema Information File The following example of a Schema.ini file specifies the format for the fixed-width file Filename.txt and the delimited file Delimit.txt: [Filename.txt] ColNameHeader=False Format=FixedLength MaxScanRows=25 CharacterSet=OEM Col1=columnname Char Width 24 Col2=columnname2 Date Width 9 Col3=columnname7 Float Width 10 Col4=columnname8 Integer Width 10 Col5=columnname9 LongChar Width 10 [Delimit.txt] ColNameHeader=True Format=Delimited(!) MaxScanRows=0 CharacterSet=OEM Col1=username Text Col2=dateofbirth DateTime

csv in Recordset einlesen	8.982	jenst	23.09.03 11:06
Re: csv in Recordset einlesen	5.992	SL	23.09.03 12:57
Fortsetzung	5.368	SL	23.09.03 12:58
Gegenfrage	5.025	SL	23.09.03 13:01
Re: csv in Recordset einlesen	7.831	jenst	23.09.03 13:57
Re: csv in Recordset einlesen	5.000	Sacha Kreher	23.01.06 13:37

Sie sind nicht angemeldet! Um auf diesen Beitrag zu antworten oder neue Beiträge schreiben zu können, müssen Sie sich zunächst anmelden. Einloggen  |  Neu registrieren

Funktionen:  Zum Thema  |  Gesamtübersicht

Suchen