Schema.ini format and creation

  • Thread starter Thread starter John
  • Start date Start date
In addition, when you create a Spec in the Import Wizard, can you export the
Spec as a schema.ini file? 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.
 
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.aspx?scid=kb;EN-US;210073

Thanks
Click to expand...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_96.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting03092004.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetsdk_98.asp
http://www.c-sharpcorner.com/database/Connect/ConnectODBCText.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.
 
Back
Top