What is the format for a Schema.ini file?

"How to Create a Schema.ini File Programmatically"
creates a delimited Schema.ini file. Is there a vba function
for fixed width output.
http://support.microsoft.com/default...b;EN-US;210073

Thanks

In addition, when you create a Spec in the Import Wizard, can you export the
Spec as a schema.ini file? Thanks


"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What is the format for a Schema.ini file?
>
> "How to Create a Schema.ini File Programmatically"
> creates a delimited Schema.ini file. Is there a vba function
> for fixed width output.
> http://support.microsoft.com/default...b;EN-US;210073
>
> Thanks
>
>

The URL you quoted has an example of a
Fixed Length
table.

I note that the KB URL you quoted is NOT the url for the
KB title you quoted.



"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> What is the format for a Schema.ini file?
>
> "How to Create a Schema.ini File Programmatically"
> creates a delimited Schema.ini file. Is there a vba function
> for fixed width output.
> http://support.microsoft.com/default...b;EN-US;210073
>
> Thanks
>
>

On Sun, 23 May 2004 23:34:21 -0700, "John" <(E-Mail Removed)>
ejaculated:

>What is the format for a Schema.ini file?
>
>"How to Create a Schema.ini File Programmatically"
>creates a delimited Schema.ini file. Is there a vba function
>for fixed width output.
>http://support.microsoft.com/default...b;EN-US;210073
>
>Thanks
>

http://msdn.microsoft.com/library/de...cjetsdk_96.asp
http://msdn.microsoft.com/library/de...ng03092004.asp
http://msdn.microsoft.com/library/de...cjetsdk_98.asp
http://www.c-sharpcorner.com/databas...ctODBCText.asp

I think a couple of these might be dead...

Anyway, here is a sample of a SCHEMA.INI I ended up creating based on
information I gleaned above:

[myfixedfile.asc]
ColNameHeader=False
Format=FixedLength
MaxScanRows=25
CharacterSet=OEM
DateTimeFormat=YYMMDD
Col1=ID Char Width 8
Col2=RESP Char Width 3
Col3=CRDATE Date Width 7
Col4=TRDATE Date Width 7
Col5=TRTIME Char Width 7

Note that you can't get nonstandard widths, like 7 for dates, if you
use the ODBC data connection wizard referenced by the
c-sharpcorner.com website above. The extra space is to consume the
space between CRDATE and TRDATE.

I'm not sure of the range of valid values for DateTimeFormat.

--
What do you get when you multiply 6 by 9?