Hello Jana,

Sesame can export to a comma delimited standard ASCII file which you can then open in Excel. Exporting data is covered on pages 288-298. In step 8 just end your filename with .csv

In Excel click Open
Browse to were your export file is
Where it says files of type change to one that includes *.csv
Then open your export file

-Ray

Justjana, a simple ASCII export from Sesame's export spec should do just what you need, remember to tell excel that you are using a comma separated file.

Quote:

Bob, I just ran a multilevel ODBC retrieve from Gems.db to MSWord. It does require that the default query be edited to connect the ParentID in the child table to the RecordID in the parent table in MSQuery. But other than that, it worked pretty well.

Thank you everyone with your help.  I got done what I needed to do, not the way I would have liked but it worked.  I would have liked to play around with the ODBC format, but my Excel doesn’t seem to have it, odd, strange, but true.  I am currently trying to figure out what is going on.

I have an idea I would like to implement with Sesame but I need to be able to export quickly and easily to Excel to achieve my needs.  ODBC seems the best way to go.

Thank you again

Jana

Hello Jana

Re ODBC, Excel does support ODBC, usually with no trouble.  You need to do a few things:

One time only:
1.  Creat/Define your ODBC connection.  (See Sesame instructions to do this).
2.  Need to have availablity to the source database (Start Sesame Server to connect to a Sesame database).
3.  Open Excel, click on Data, Get External data, New Database Query.
4.  Choose Data Source (Can select Sesame or other source).  Make the query and save it as  filename.dqy(dynamic query).

Make as many queries as you need to use in the future.

Future use.
1.  Be sure you have access to source database (Sesame Server is on).
2.  Open Excel, File, Open, change the type to Query(*.dqy), and select the query that you want to use.

Here is a snapshot of an ODBC connection I just made with Sesame\Data\Samples\Customers database in Excel 2000, showing all 378 records, sorted by Key.