(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Excel (Read 569 times)
reunionmance
Member
*
Offline


No personal text

Posts: 1
Joined: Mar 25th, 2006
Excel
Mar 26th, 2006 at 12:07am
Print Post Print Post  
I don't use Sesame just yet.  I am wondering does it export information to Excel besides in text format or does it have ODBC that works from within Excel to read Sesame database information?
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Excel
Reply #1 - Mar 26th, 2006 at 7:14am
Print Post Print Post  
You can export csv files to Excel.

AND

Sesame does have an ODBC driver that allows you to link to Sesame from Excel.  It currently is one-way, allowing you to read Sesame, but cannot write back to Sesame.  But you can export from Excel and import into Sesame if needed.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Excel
Reply #2 - Mar 26th, 2006 at 9:14pm
Print Post Print Post  
If you want to drive the automation from within Excel, you can also use Sesame Extractor - a command line driven data extractor for Sesame.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge