|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I have three different versions of office on my computer (too cheap to buy
upgrades for everyone in the company, so I still develop in 97. Something has
changed in all three versions so that I cannot import or link to .csv, .txt ,
..xls like I could. I have uninstalled them, used ORK to clean up,
reinstalled, selected all the file types for converters and the only options
that show up when I try to import are Access files, ODBC or xml. Is there a
registry tweak or something I can do to get that functionality back?
Thanks
--
Judy
|
|
Judy wrote:
[Quoted Text] > I have three different versions of office on my computer (too cheap
> to buy upgrades for everyone in the company, so I still develop in
> 97. Something has changed in all three versions so that I cannot
> import or link to .csv, .txt , .xls like I could. I have uninstalled
> them, used ORK to clean up, reinstalled, selected all the file types
> for converters and the only options that show up when I try to import
> are Access files, ODBC or xml. Is there a registry tweak or something
> I can do to get that functionality back?
> Thanks
You need to make sure the ISAM driver for text files is installed. This comes
from MDAC or from your Office install, but might not be installed by default.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
|
I have selected that to install everytime I've tried it. It just doesn't
happen, though. Is there a way I can register it manually or anything? Do you
know the name of the file or where it is located?
--
Judy
"Rick Brandt" wrote:
[Quoted Text] > Judy wrote:
> > I have three different versions of office on my computer (too cheap
> > to buy upgrades for everyone in the company, so I still develop in
> > 97. Something has changed in all three versions so that I cannot
> > import or link to .csv, .txt , .xls like I could. I have uninstalled
> > them, used ORK to clean up, reinstalled, selected all the file types
> > for converters and the only options that show up when I try to import
> > are Access files, ODBC or xml. Is there a registry tweak or something
> > I can do to get that functionality back?
> > Thanks
>
> You need to make sure the ISAM driver for text files is installed. This comes
> from MDAC or from your Office install, but might not be installed by default.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
|
|
I just ran MDAC component checker and it says I have MDAC 2.8 SP1 on Win XP
SP2. When I tried to install MDAC 2.8, it said MDAC 2.8 RTM is incompatible
with this version of Windows. All of its features are currently part of
Windows.
--
Judy
"Judy" wrote:
[Quoted Text] > I have selected that to install everytime I've tried it. It just doesn't
> happen, though. Is there a way I can register it manually or anything? Do you
> know the name of the file or where it is located?
> --
> Judy
>
>
> "Rick Brandt" wrote:
>
> > Judy wrote:
> > > I have three different versions of office on my computer (too cheap
> > > to buy upgrades for everyone in the company, so I still develop in
> > > 97. Something has changed in all three versions so that I cannot
> > > import or link to .csv, .txt , .xls like I could. I have uninstalled
> > > them, used ORK to clean up, reinstalled, selected all the file types
> > > for converters and the only options that show up when I try to import
> > > are Access files, ODBC or xml. Is there a registry tweak or something
> > > I can do to get that functionality back?
> > > Thanks
> >
> > You need to make sure the ISAM driver for text files is installed. This comes
> > from MDAC or from your Office install, but might not be installed by default.
> >
> > --
> > Rick Brandt, Microsoft Access MVP
> > Email (as appropriate) to...
> > RBrandt at Hunter dot com
> >
> >
> >
|
|
Judy wrote:
[Quoted Text] > I have selected that to install everytime I've tried it. It just
> doesn't happen, though. Is there a way I can register it manually or
> anything? Do you know the name of the file or where it is located?
Go you have the following registry entry?
(the second and third lines are actually one line)
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
\ODBCINST.INI\Microsoft Text Driver (*.txt; *.csv)]
"UsageCount"=dword:00000002
"Driver"="C:\\WINDOWS\\System32\\odbcjt32.dll"
"Setup"="C:\\WINDOWS\\System32\\odtext32.dll"
"APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
"SQLLevel"="0"
"CPTimeout"="<not pooled>"
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|
|
I don't have "CPTimeout"="<not pooled>"
and this is different:
I have
"UsageCount"=dword:0x00000003(3)
instead of
"UsageCount"=dword:00000002
--
Judy
"Rick Brandt" wrote:
[Quoted Text] > Judy wrote:
> > I have selected that to install everytime I've tried it. It just
> > doesn't happen, though. Is there a way I can register it manually or
> > anything? Do you know the name of the file or where it is located?
>
> Go you have the following registry entry?
> (the second and third lines are actually one line)
>
> Windows Registry Editor Version 5.00
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
> \ODBCINST.INI\Microsoft Text Driver (*.txt; *.csv)]
> "UsageCount"=dword:00000002
> "Driver"="C:\\WINDOWS\\System32\\odbcjt32.dll"
> "Setup"="C:\\WINDOWS\\System32\\odtext32.dll"
> "APILevel"="1"
> "ConnectFunctions"="YYN"
> "DriverODBCVer"="02.50"
> "FileUsage"="1"
> "FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv"
> "SQLLevel"="0"
> "CPTimeout"="<not pooled>"
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>
|
|
|