473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Office 97 Value Pack

I've been having problems with Access and Excel talking to one another.
In the process of trying to add features (programs) to Access 97 I have lost
the ability to export an Access query to an external file in Excel 97 format.
It was there yesterday, but it's gone today. Other formats are also gone. I
have found the Value Pack on the original Office 97 Pro CD. It looks like I
can install drivers directly from the value pack. There is an awful lot in the
Value Pack. I would appreciate any suggestions on what I should install and
where I should install it. MSAccess.exe is currently installed in
C:\Windows\Program Files\Microsoft Office\ There are many sub-directories
under Microsoft Office.

Chuck
Oct 7 '08 #1
3 4935
On Oct 7, 4:47*pm, Chuck <libb...@schoollink.netwrote:
I've been having problems with Access and Excel talking to one another.
In the process of trying to add features (programs) to Access 97 I have lost
the ability to export an Access query to an external file in Excel 97 format.
It was there yesterday, but it's gone today. *Other formats are also gone. *I
have found the Value Pack on the original Office 97 Pro CD. *It looks like I
can install drivers directly from the value pack. *There is an awful lot in the
Value Pack. *I would appreciate any suggestions on what I should install and
where I should install it. *MSAccess.exe is currently installed in
C:\Windows\Program Files\Microsoft Office\ * There are many sub-directories
under Microsoft Office.

Chuck
I remember having a similar problem some years ago - one day I
couldn't import Excel files. A cry for help here got me this info:

I recommend re-registering the following two files. Note that the path
to
each file may be different on your PC. To do this, click on Start >
Run. Then
copy each of the statements shown below, one-at-a-time, and click on
OK:

Regsvr32.exe "C:\program files\common files\microsoft shared\dao
\dao360.dll"
Regsvr32.exe "C:\program files\common files\system\ado\Msado15.dll"

Optional, but won't hurt is to make sure that dao350.dll is also
properly
registered:
Regsvr32.exe "C:\program files\common files\microsoft shared\dao
\dao350.dll"

If a library is marked MISSING, click the Browse button, and locate
the correct file for the library. The table below lists the files for
the crucial libraries of your version of Access.

If the library is not even shown, you may need to re-register it.
Click the Windows Start button, and choose Run. Enter regsvr32
followed by the full path of the library file. Include quotes if the
file name contains spaces, e.g.:
regsvr32 "c:\program files\common files\microsoft shared\dao
\dao360.dll"

Occasionally, the problem is not solved until you unregister the
library and re-register it. Uncheck the missing library in Access.
Close Access. Issue this command, and then the one above to re-
register it:
regsvr32 -u "c:\program files\common files\microsoft shared\dao
\dao360.dll"
Re-register it (as above). Open Access, and select the library
reference again.

********THE FOLLOWING IS WHAT WORKED FOR ME********

"Sounds like your DAO library got un-registered somehow. (Office 97
installation doesn't register it properly in the first place, so
re-installing is no help.)

Go to Start menu|Run, type the following, and click OK:
regsvr32 "C:\Program Files\Common Files\Microsoft
Shared\DAO\dao350.dll"

You can also check to make sure your references are ok (open any code
module, go to Tools menu|References, and make sure nothing is marked
"MISSING").

If I remember rightly this came from a wonderful lady named Martha and
it saved my sanity!

HTH

Jeff B
Oct 8 '08 #2
On Tue, 07 Oct 2008 11:47:04 -0400, Chuck <li*****@schoollink.netwrote:
>I've been having problems with Access and Excel talking to one another.
In the process of trying to add features (programs) to Access 97 I have lost
the ability to export an Access query to an external file in Excel 97 format.
It was there yesterday, but it's gone today. Other formats are also gone. I
have found the Value Pack on the original Office 97 Pro CD. It looks like I
can install drivers directly from the value pack. There is an awful lot in the
Value Pack. I would appreciate any suggestions on what I should install and
where I should install it. MSAccess.exe is currently installed in
C:\Windows\Program Files\Microsoft Office\ There are many sub-directories
under Microsoft Office.

Chuck
I gave up trying to get the proper files in the value pack installed in the
right directories in the C drive. I restored the complete C drive from my
backup.
No data files are on the C drive so I didn't have to use my incremental backups
to get my data files up to date.

Chuck
--

Oct 9 '08 #3
On Oct 9, 12:27 pm, Chuck <libb...@schoollink.netwrote:
I gave up trying to get the proper files in the value pack installed in the
right directories in the C drive. I restored the complete C drive from my
backup.
No data files are on the C drive so I didn't have to use my incremental backups
to get my data files up to date.

Chuck
--
I ran into that problem earlier this year. Some registry entries got
deleted somehow. I think they were the ones in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM Formats\

I was able to bring back most of the import/export types by fixing
those entries by comparing with the registry settings on another
machine running Access 97. That seemed not to fix everything
perfectly so I think I wiped Office key references, folders, etc. out
of the registry entirely and did a clean install of Office (after
noting that simply reinstalling or fixing Office without changing the
registry did not allow the Access installation to write the correct
ISAM folders/entries into the registry -- don't ask me why). Merely
restoring the registry from a previous point might have solved your
problem. Also, note that is better not to choose "SQL Server" as an
option when installing Access 97 unless you really need it.

James A. Fortune
CD********@FortuneJames.com
Oct 12 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: VK | last post by:
Hi! What I'm missing in following code? Cannot get the values of radiobuttons. Starting only one class (GetVariant), it works. When I put two classes together, it doesn't. Regards, VK from...
2
by: thierry | last post by:
hi, i've download pia office for c# i've install them in the gac i've made a reference in my c# code and it seems to work well as i can acess to the property of the excel object i've created...
3
by: Mike Pace | last post by:
When I package my Microsoft Access 2002 application with the Office XP Developer Packaging Wizard, and include the runtime, the resulting OSP1.CAB file that is created does not contain the latest...
1
by: CR | last post by:
We're writing an application in C# that needs to programmatically check if Office XP is installed on the computer and, if so, what service pack level is it at. Another application that we have...
11
by: Don | last post by:
QUESTIONS: 1. Has anyone figured out how to successfully install the Office 97 Pro Service Release 2 patch in Vista? 2. Has anyone successfully installed an Office 97 Pro CD (SR2 version) in...
2
by: =?Utf-8?B?RWxsZW4=?= | last post by:
Using XP (English). I left this huge update running to download as I am on dial up. When I got back to computer (said the download would take 68 hours) I recd an error message saying: System has...
4
by: Juhein½juhein | last post by:
Hello. If someone could lighten me up on this problem I would be very crateful. So I´m trying to deploy office 2003 with SP3 update and with MUI pack for finnish spell check. There is no...
0
by: ray007x | last post by:
I have a question for Beth Melton. Hello. This is Ray. I read an answer you graciously gave to another user about the constant popping up of "Windows Installer - Preparing to install". I cannot...
3
by: sarabonn | last post by:
hallo everyone, Actually i know how to drag and drop text file into WPF and read it but i need to drag and drop office 2007 file and extract the file and the xml file in...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.