<div>
Man, I have to go home and check my &quot;Legacy&quot; machine to try this in Access 97.<br />
<br />
I do recall that option definitley being there though.<br />
What choices are available for exporting in Access 97?<br />
<br />
What type of object are you trying to Export?<br />
You can only Export Tables or Queries. (Not forms or Reports)<br />
<br />
If you ar trying to Export a Form or Report, you should export the &quot;RecordSource&quot;.<br />
<br />
You can simply export the Table/Query object as a CSV file, and it should come into Excel 2003 just fine.<br />
<br />
JeffCoachman
</div>


Man, I have to go home and check my "Legacy" machine to try this in Access 97.

I do recall that option definitley being there though.
What choices are available for exporting in Access 97?

What type of object are you trying to Export?
You can only Export Tables or Queries. (Not forms or Reports)

If you ar trying to Export a Form or Report, you should export the "RecordSource".

You can simply export the Table/Query object as a CSV file, and it should come into Excel 2003 just fine.

JeffCoachman

<div>
Looks like the initial installation of Access 97 only installed the default file types. Reinstalled, selecting all file types and now it works.<br />
<br />
thanks for you time anyway. 
</div>


Looks like the initial installation of Access 97 only installed the default file types. Reinstalled, selecting all file types and now it works.

thanks for you time anyway.

<div>
<div class="content wysiwyg-content">
When trying to &quot;save as/export within Access 97 I have no option to save/export to Excel in the &quot;save as type&quot;. &nbsp;I have already registered msexcl40.dll successfully, but this has unfortunately made no difference. <br />
Using Xp and Excel 2003. &nbsp;Any help would be appreciated.<br />
<br />
Thanks
</div>
</div>


When trying to "save as/export within Access 97 I have no option to save/export to Excel in the "save as type".  I have already registered msexcl40.dll successfully, but this has unfortunately made no difference. 
Using Xp and Excel 2003.  Any help would be appreciated.

Thanks

Missing Excel from &quot;Save as type&quot; when exporting

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Missing Excel from &quot;Save as type&quot; when exporting

Missing Excel from "Save as type" when exporting