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

[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?

 

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

 

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

 

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

 

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

 

[BethanyJ]

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!