Exporting to Excell

[rmsherman]

Can anyone describe the steps to be taken to export data to an excell spreadsheet? Or can someone direct me to a simple step by step descritpion of this process. The help menu does not help me. Thanks.

[Kurt Knippel]

quote:

---

Originally posted by rmsherman:

Can anyone describe the steps to be taken to export data to an excell spreadsheet? Or can someone direct me to a simple step by step descritpion of this process. The help menu does not help me. Thanks.

---

Find the data you want to export.

Select export from the File menu.

Choose the filename, location and select Comma-Seperated Text, then press Save.

Select the fields that you want to export and press Export.

Now open Excel.

Use the Open File menu item in Excel, and find the exported file and open it.

Excel will prompt you with a series of question on how the data is formatted, answer as many of as few as you need.

You can also export in a "Merge" format, which will export field names with the data.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected] http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[This message has been edited by captkurt (edited October 06, 2000).]