Cannot import .csv files

[Judy]

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

 

[Rick Brandt]

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.

 

[Judy]

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]

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.

 

[Rick Brandt]

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>"

 

[Judy]

I don't have "CPTimeout"="<not pooled>"
and this is different:
I have
"UsageCount"=dword:0x00000003(3)
instead of
"UsageCount"=dword:00000002


--
Judy

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>"