dbTalk Databases Forums  

Help - no import for Text Files Option in Dialog Box

comp.database.ms-access comp.database.ms-access


Discuss Help - no import for Text Files Option in Dialog Box in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Child of His
 
Posts: n/a

Default Help - no import for Text Files Option in Dialog Box - 11-11-2006 , 07:57 PM






I have Office 97 Pro installed on a Win 98SE system. Previously the
machine had parts of Office 2000 installed. It was given to me that
way, and I didn't own those versions, so I cleaned out every trace I
could find, and then installed both Win 98SE and Office 97 again.

It is working great with one problem. When you look at the file type
list in the Access import window, there is no option for text files of
any kind. Both Word, and Excel are free of this problem, and they cope
fine. I tried repeatedly to install the required files in Setup. It
always opens showing some are not installed, and when I uninstall them
all, and reinstall them all, it says it was successful, but it never
is. I think there is a later file, probably from Office 2000 still
floating about, and that Office 97 Setup won't overwrite it.



Reply With Quote
  #2  
Old   
Ken Snell
 
Posts: n/a

Default Re: Help - no import for Text Files Option in Dialog Box - 11-22-2006 , 07:04 AM






Might be a problem with the wizard not being registered correctly. Try
re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.


If this doesn't fix the problem, you may need to run a repair on your Office
installation.

--

Ken Snell
<MS ACCESS MVP>
"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Quote:
I have Office 97 Pro installed on a Win 98SE system. Previously the
machine had parts of Office 2000 installed. It was given to me that
way, and I didn't own those versions, so I cleaned out every trace I
could find, and then installed both Win 98SE and Office 97 again.

It is working great with one problem. When you look at the file type
list in the Access import window, there is no option for text files of
any kind. Both Word, and Excel are free of this problem, and they cope
fine. I tried repeatedly to install the required files in Setup. It
always opens showing some are not installed, and when I uninstall them
all, and reinstall them all, it says it was successful, but it never
is. I think there is a later file, probably from Office 2000 still
floating about, and that Office 97 Setup won't overwrite it.





Reply With Quote
  #3  
Old   
Child of His
 
Posts: n/a

Default Re: Help - no import for Text Files Option in Dialog Box - 11-22-2006 , 12:09 PM



Thanks, Ken!

You sound like you know your way around the insides of the system. I
did as you advised, and used the drag-and-drop method to put
Accwiz.dll onto regsvr32.exe. Both were in the Windows/System folder.
I got a message that is successfully completed, but there was no
change in Access. It simply doesn't list any text files in the list of
importable files in the dialog box.

So, now, I'll try the repair. It is a bit complicated, because my disk
is SR-1. I have the SR-2 download, and will run it after the repair,
if it seems to be necessary. Sometimes I'm lucky. I'll let you know
how it works.

I had a lot of trouble with Office 97 when I first installed it in a
different directory from a partial install of Office 2000. Later I
uninstalled 2000, but it seemed to have left a whole lot of stuff
behind, and reinstalling or repairing 97 didn't improve things.

So, I finally uninstalled 97, and then used the wonderful delete key
on every file or folder that looked like it might have anything to do
with Office of any kind. Granted, a bit of a judgment call, and
something else was sure to break, but I didn't want to have to
reinstall all four Gigs of stuff - no backup then, just original
disks - Then I used Registry Mechanic to clean out over 400 problems,
that I assume I created. Finally, I did a reinstall of Win 98SE, and
the wonderful thing found all my other stuff. The only other thing
that seemed broken was Project 2000, which I own and had installed.
So, I uninstalled Project, blew away anything of Project or Office I
could find, ran Reg Mech again, and reinstalled Win 98SE again. Then I
installed Office 97, and everything but this text file thing works
great! I finally reinstalled Project 2000 as well, and it works fine.
Nothing else seemed broken.

I now have backups on a 250 Gig external drive on a USB port. But, if
I screw it us, and reinstall the same thing, I don't see I have gotten
anywhere. I suppose I should do a reformat of C, and reinstall
everything from scratch, but I really don't want to do that. It would
take me months to get it all reconfigured, and all the new tool bar
adjustments, and and and... I know you understand.

That's why I keep thinking that if I could find the specific files
that do the import function in Access, and delete them all, I could
then reinstall them from the disk, and have only the Office 97
versions. But I just don't understand all this well enough.

Thanks again. If you have other suggestions, I'll love to try them. I
guess I'll try the repair, and see what happens.

Bye,

Ray Clare
"Ken Snell" <kthsneisllis9 (AT) ncoomcastt (DOT) renaetl> wrote

Might be a problem with the wizard not being registered correctly. Try
re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.


If this doesn't fix the problem, you may need to run a repair on your
Office
installation.

--

Ken Snell
<MS ACCESS MVP>
"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Quote:
I have Office 97 Pro installed on a Win 98SE system. Previously the
machine had parts of Office 2000 installed. It was given to me that
way, and I didn't own those versions, so I cleaned out every trace I
could find, and then installed both Win 98SE and Office 97 again.

It is working great with one problem. When you look at the file type
list in the Access import window, there is no option for text files
of
any kind. Both Word, and Excel are free of this problem, and they
cope
fine. I tried repeatedly to install the required files in Setup. It
always opens showing some are not installed, and when I uninstall
them
all, and reinstall them all, it says it was successful, but it never
is. I think there is a later file, probably from Office 2000 still
floating about, and that Office 97 Setup won't overwrite it.






Reply With Quote
  #4  
Old   
Child of His
 
Posts: n/a

Default Re: Help - no import for Text Files Option in Dialog Box - 11-22-2006 , 12:37 PM



More:

I tried removing the text data files with setup, and reinstalling
again, as I have before. It simply won't mess with them. It won't
remove them, or reinstall the. The box is blued, and a couple of
components are stuck that way.

I tried reinstall, and it didn't take long, since it wouldn't
reinstall anything, either.

Any chance we can find some folder and blow those files away, and then
try repair?

Blessings.

Thanks for the help so far.


"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Thanks, Ken!

You sound like you know your way around the insides of the system. I
did as you advised, and used the drag-and-drop method to put
Accwiz.dll onto regsvr32.exe. Both were in the Windows/System folder.
I got a message that is successfully completed, but there was no
change in Access. It simply doesn't list any text files in the list of
importable files in the dialog box.

So, now, I'll try the repair. It is a bit complicated, because my disk
is SR-1. I have the SR-2 download, and will run it after the repair,
if it seems to be necessary. Sometimes I'm lucky. I'll let you know
how it works.

I had a lot of trouble with Office 97 when I first installed it in a
different directory from a partial install of Office 2000. Later I
uninstalled 2000, but it seemed to have left a whole lot of stuff
behind, and reinstalling or repairing 97 didn't improve things.

So, I finally uninstalled 97, and then used the wonderful delete key
on every file or folder that looked like it might have anything to do
with Office of any kind. Granted, a bit of a judgment call, and
something else was sure to break, but I didn't want to have to
reinstall all four Gigs of stuff - no backup then, just original
disks - Then I used Registry Mechanic to clean out over 400 problems,
that I assume I created. Finally, I did a reinstall of Win 98SE, and
the wonderful thing found all my other stuff. The only other thing
that seemed broken was Project 2000, which I own and had installed.
So, I uninstalled Project, blew away anything of Project or Office I
could find, ran Reg Mech again, and reinstalled Win 98SE again. Then I
installed Office 97, and everything but this text file thing works
great! I finally reinstalled Project 2000 as well, and it works fine.
Nothing else seemed broken.

I now have backups on a 250 Gig external drive on a USB port. But, if
I screw it us, and reinstall the same thing, I don't see I have gotten
anywhere. I suppose I should do a reformat of C, and reinstall
everything from scratch, but I really don't want to do that. It would
take me months to get it all reconfigured, and all the new tool bar
adjustments, and and and... I know you understand.

That's why I keep thinking that if I could find the specific files
that do the import function in Access, and delete them all, I could
then reinstall them from the disk, and have only the Office 97
versions. But I just don't understand all this well enough.

Thanks again. If you have other suggestions, I'll love to try them. I
guess I'll try the repair, and see what happens.

Bye,

Ray Clare
"Ken Snell" <kthsneisllis9 (AT) ncoomcastt (DOT) renaetl> wrote

Might be a problem with the wizard not being registered correctly. Try
re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.


If this doesn't fix the problem, you may need to run a repair on your
Office
installation.

--

Ken Snell
<MS ACCESS MVP>
"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Quote:
I have Office 97 Pro installed on a Win 98SE system. Previously the
machine had parts of Office 2000 installed. It was given to me that
way, and I didn't own those versions, so I cleaned out every trace I
could find, and then installed both Win 98SE and Office 97 again.

It is working great with one problem. When you look at the file type
list in the Access import window, there is no option for text files
of
any kind. Both Word, and Excel are free of this problem, and they
cope
fine. I tried repeatedly to install the required files in Setup. It
always opens showing some are not installed, and when I uninstall
them
all, and reinstall them all, it says it was successful, but it never
is. I think there is a later file, probably from Office 2000 still
floating about, and that Office 97 Setup won't overwrite it.








Reply With Quote
  #5  
Old   
Ken Snell
 
Posts: n/a

Default Re: Help - no import for Text Files Option in Dialog Box - 11-24-2006 , 11:38 AM



I don't have a copy of ACCESS 97, so I'm afraid I cannot offer specific
information about how it's installed/set up.

If the reinstall, repair, and registering of wizard file didn't work, I
don't know of other suggestions.

However, try posting your question in comp.databases.ms-access newsgroup
(note the "s" at end of database); many more people will see your post and
may have better suggestions.
--

Ken Snell
<MS ACCESS MVP>



"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Quote:
More:

I tried removing the text data files with setup, and reinstalling
again, as I have before. It simply won't mess with them. It won't
remove them, or reinstall the. The box is blued, and a couple of
components are stuck that way.

I tried reinstall, and it didn't take long, since it wouldn't
reinstall anything, either.

Any chance we can find some folder and blow those files away, and then
try repair?

Blessings.

Thanks for the help so far.


"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote

Thanks, Ken!

You sound like you know your way around the insides of the system. I
did as you advised, and used the drag-and-drop method to put
Accwiz.dll onto regsvr32.exe. Both were in the Windows/System folder.
I got a message that is successfully completed, but there was no
change in Access. It simply doesn't list any text files in the list of
importable files in the dialog box.

So, now, I'll try the repair. It is a bit complicated, because my disk
is SR-1. I have the SR-2 download, and will run it after the repair,
if it seems to be necessary. Sometimes I'm lucky. I'll let you know
how it works.

I had a lot of trouble with Office 97 when I first installed it in a
different directory from a partial install of Office 2000. Later I
uninstalled 2000, but it seemed to have left a whole lot of stuff
behind, and reinstalling or repairing 97 didn't improve things.

So, I finally uninstalled 97, and then used the wonderful delete key
on every file or folder that looked like it might have anything to do
with Office of any kind. Granted, a bit of a judgment call, and
something else was sure to break, but I didn't want to have to
reinstall all four Gigs of stuff - no backup then, just original
disks - Then I used Registry Mechanic to clean out over 400 problems,
that I assume I created. Finally, I did a reinstall of Win 98SE, and
the wonderful thing found all my other stuff. The only other thing
that seemed broken was Project 2000, which I own and had installed.
So, I uninstalled Project, blew away anything of Project or Office I
could find, ran Reg Mech again, and reinstalled Win 98SE again. Then I
installed Office 97, and everything but this text file thing works
great! I finally reinstalled Project 2000 as well, and it works fine.
Nothing else seemed broken.

I now have backups on a 250 Gig external drive on a USB port. But, if
I screw it us, and reinstall the same thing, I don't see I have gotten
anywhere. I suppose I should do a reformat of C, and reinstall
everything from scratch, but I really don't want to do that. It would
take me months to get it all reconfigured, and all the new tool bar
adjustments, and and and... I know you understand.

That's why I keep thinking that if I could find the specific files
that do the import function in Access, and delete them all, I could
then reinstall them from the disk, and have only the Office 97
versions. But I just don't understand all this well enough.

Thanks again. If you have other suggestions, I'll love to try them. I
guess I'll try the repair, and see what happens.

Bye,

Ray Clare
"Ken Snell" <kthsneisllis9 (AT) ncoomcastt (DOT) renaetl> wrote in message
news:AfydnWTeP8yn1vnYnZ2dnUVZ_qudnZ2d (AT) comcast (DOT) com...
Might be a problem with the wizard not being registered correctly. Try
re-registering this file:
Accwiz.dll

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.

Or run from Start | Run window (example):
Regsvr32 "path\msexcl40.DLL"

etc.


If this doesn't fix the problem, you may need to run a repair on your
Office
installation.

--

Ken Snell
MS ACCESS MVP
"Child of His" <AmoreDei (AT) hotmail (DOT) com> wrote in message
news:vsadnQskn9U04svYnZ2dnUVZ_u-dnZ2d (AT) comcast (DOT) com...
I have Office 97 Pro installed on a Win 98SE system. Previously the
machine had parts of Office 2000 installed. It was given to me that
way, and I didn't own those versions, so I cleaned out every trace I
could find, and then installed both Win 98SE and Office 97 again.

It is working great with one problem. When you look at the file type
list in the Access import window, there is no option for text files
of
any kind. Both Word, and Excel are free of this problem, and they
cope
fine. I tried repeatedly to install the required files in Setup. It
always opens showing some are not installed, and when I uninstall
them
all, and reinstall them all, it says it was successful, but it never
is. I think there is a later file, probably from Office 2000 still
floating about, and that Office 97 Setup won't overwrite it.










Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.