ODBC link to a spreadsheet

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
eddu
Posts: 8
Joined: Fri May 12, 2006 7:27 pm

ODBC link to a spreadsheet

Post by eddu » Fri May 12, 2006 7:33 pm

I rather use a local spreadsheet instead of a MySQL or other database.
There is not very much information about how to use or apply a ODBC link to a spreadsheet. Does anyone has an example of such a application/script?

Regards;
Ed

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Location: Aalst, Belgium
Contact:

Post by Janschenkel » Fri May 12, 2006 8:46 pm

Hi Ed,

If you're on Windows, you can create a DSN in your ODBC Control Panel, using the Microsoft Excel driver.
Then you can connect from Rev using something like:

Code: Select all

put revdb_connect("odbc",<DSN name>,,<username>,<password>) into tConnectionID
And then use the connection ID in conjunction with the other revdb commands and functions.

Hope this helped,

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

eddu
Posts: 8
Joined: Fri May 12, 2006 7:27 pm

And on Mac??

Post by eddu » Sat May 13, 2006 2:56 pm

And what if you are on mac?

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Location: Aalst, Belgium
Contact:

Post by Janschenkel » Sun May 14, 2006 6:40 am

Unfortunately, some googling didn't turn up an ODBC Excel driver on MacOS. You could use AppleScript to talk to Excel, but that means you'll have to keep both Excel and your Rev-based solution open at the same time.
Of course you can store the data in MySQL, and then you can always use Excel to query this database through ODBC, for the purpose of reviewing what data is in it.

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

Post Reply

Return to “Databases”