Exporting from access to excel

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I'm having a problem exporting from Access 97 to Excel.
When I export the file it says "Can't update. Database or
object is read only." I've uninstalled and reinstalled
and also downloaded the lastest jet sp8 but nothing
helps. Here's a weird twist. When the length of the
filename is less than 14 characters then it works. Any
help would be appreciated.
 
I seem to recall that 97 has a limit on the length of the path string to the
file; 64 characters sticks in my memory?

Try using a shorter path, or use the DOS names of the folders and file
instead of the long names.

I've also had it fail a few times when there are spaces in the path and/or
filename.
 
This may help:

Q245407

The file that you are importing does not have a recognized file name
extension

Security patches to Access 97 and Access 2000 restrict the kinds of
files you can import. That restriction is based solely on the file
extension. By default, Jet will let you import files having the
extensions "txt", "csv", "tab", "asc", "htm", and "html".

Rename the file name extension so that it matches one of extensions listed
in the registry.
-or-
Modify the following registry key to include the extension of the file that
you are importing.

See the settings in:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Xbase
Extensions = "dbf" might be changed to "dbf,xyz"

HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtension
s
add the entry:
"DisabledExtensions"="exe"
and the Import wizard/TransferText will work on a file with any extension.
 
Back
Top