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
ODBC link to a spreadsheet
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- VIP Livecode Opensource Backer
- Posts: 977
- Joined: Sat Apr 08, 2006 7:47 am
- Location: Aalst, Belgium
- Contact:
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:
And then use the connection ID in conjunction with the other revdb commands and functions.
Hope this helped,
Jan Schenkel.
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
Hope this helped,
Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com
www.quartam.com
-
- VIP Livecode Opensource Backer
- Posts: 977
- Joined: Sat Apr 08, 2006 7:47 am
- Location: Aalst, Belgium
- Contact:
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.
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
www.quartam.com