Unable to import Text files into Access 97 after Office 97 SR-2 Patch install

[RonW]

This is what I had to do for the SR-1 version of Office 97 to import
text files into Access 97:

[Start] - [Run...] - Open: regsvr32 mstext35.dll - [Ok]

Once I registered the mstext35.dll, I was able to import text files
and it's been working until I installed the SR-2 Patch. The Access 97
help file says something about a SCHEMA.INI file that has to be
created. Here's what the help file says:

----------------------------------------------------------------------Start

When you install the Text Data Source database driver, the Setup
program writes a set of default values to the Windows Registry in the
Engines and ISAM Formats subkeys. You should not modify these settings
directly; use the setup program for your application to add, remove,
or change these settings. The following sections describe
initialization and ISAM Format settings for the Text Data Source
database driver.

Text Data Source Initialization Settings

The Jet\3.5\Engines\Text folder includes initialization settings for
the Mstext35.dll driver, used for external access to text data files.
Typical settings for the entries in this folder are shown in the
following example.

win32=<path>\MSTEXT35.dll
MaxScanRows=25
FirstRowHasNames=True
CharacterSet=OEM
Format=CSVDelimited
Extensions=none,asc,csv,tab,txt
ExportCurrencySymbols=Yes

To read, import, or export text data, you need to create a Schema.ini
file in addition to including the Text ISAM information in the .ini
file. Schema.ini contains the specifics of a text data source: how the
text file is formatted, how it is read at import time, and the default
export format for files. The following examples show the layout for a
fixed-width file, Filename.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

Similarly, the format for a delimited file is specified as follows:

[Delimit.txt]
ColNameHeader=True
Format=Delimited(!)
MaxScanRows=0
CharacterSet=OEM
Col1=username char width 50
Col2=dateofbirth Date width 9

If you are exporting data into a delimited text file, specify the
format for that file as well.

[Export: My Special Export]
ColNameHeader=True
Format=TabDelimited
MaxScanRows=25
CharacterSet=OEM
DateTimeFormat=mm.dd.yy.hh.mm.ss
CurrencySymbol=Dm
CurrencyPosFormat=0
CurrencyDigits=2
CurrencyNegFormat=0
CurrencyThousandSymbol=,
CurrencyDecimalSymbol=.
DecimalSymbol=,
NumberDigits=2
NumberLeadingZeros=0

The My Special Export example refers to a specific export option; you
can specify any variation of export options at connect time. This last
example also corresponds to a data source name (DSN) that can be
optionally passed at connect time. All three format sections can be
included in the same .ini file.
----------------------------------------------------------------------End

Where do I put this schema.ini file and why do I need it? I never had
to do this before.

In Access 97 under the menu item [File ], the [Get External Data] is
disabled. How do I enable this item?

I tried installing M:\VALUPACK\DATAACC\DATAACC.EXE off the SR-2 patch
CD but that didn't seem to help.

Any advice would be GREATLY appreciated.

Thank, Ron

[Michael (michka) Kaplan]

you do not need any of this. try

msaccess /unregserver
regsvr32 /u mstext35.dll
regsvr32 mstext35.dll
msaccess /regserver

and don't worry about schema.ini files.

--
MichKa

-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)

random junk of dubious value is at:
http://www.trigeminal.com

RonW <Fa...@address.com> wrote in message
news:7ncv5r$d...@newsops.execpc.com...