The formats that enable you to output data as a Microsoft Excel, rich-text forma

W

wlyarnell

I get the following error when exporting from Access to
Excel: "The formats that enable you to output data as a
Microsoft Excel, rich-text format, MS-DOS text, or HTML
file are missing from the Windows Registry.
" The path, name, etc. are correct. Does anyone know how
to fix this?
 
J

John Nurick

Try re-registering the following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

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.
 
W

wlyarnell

Thanks, I tried what you suggested and I still get the
error saying it can't open the file. Do you think it has
anything to do with the fact that it's Access 97 exporting
to Excel 2003?

Any more suggestions would be VERY appreciated.

-----Original Message-----
Try re-registering the following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

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.


I get the following error when exporting from Access to
Excel: "The formats that enable you to output data as a
Microsoft Excel, rich-text format, MS-DOS text, or HTML
file are missing from the Windows Registry.
" The path, name, etc. are correct. Does anyone know how
to fix this?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 
W

Wendy

To fix this problem, export the Access query rather than
the report itself. Excel will not rename the sheet,
therefore Access will have no problem openning the file.
 
J

John Nurick

Does http://support.microsoft.com/default.aspx?scid=kb;en-us;226526 fit
the situation?

If not, post back with more information, including what you're exporting
and how.

Thanks, I tried what you suggested and I still get the
error saying it can't open the file. Do you think it has
anything to do with the fact that it's Access 97 exporting
to Excel 2003?

Any more suggestions would be VERY appreciated.

-----Original Message-----
Try re-registering the following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

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.


I get the following error when exporting from Access to
Excel: "The formats that enable you to output data as a
Microsoft Excel, rich-text format, MS-DOS text, or HTML
file are missing from the Windows Registry.
" The path, name, etc. are correct. Does anyone know how
to fix this?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
 
Joined
May 23, 2012
Messages
1
Reaction score
0
I get the following error when exporting from Access to
Excel: "The formats that enable you to output data as a
Microsoft Excel, rich-text format, MS-DOS text, or HTML
file are missing from the Windows Registry.
" The path, name, etc. are correct. Does anyone know how
to fix this?

Hi. Changing your Windows Registry might not be necessary depending on your situation. Here's how I fixed this issue in one of my databases:
- Opened the macro in Design View containing the Transfer Spreadsheet command which was causing the error.
- Changed the "Spreadsheet Type" action argument to "Microsoft Excel 8-9"
- Changed the "File Name" action argument from a "xlsx" file extention to "xls".
The macro worked fine after making these adjustments.
Hope this helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top