Page 1 of 1
ODBC link to a spreadsheet
Posted: Fri May 12, 2006 7:33 pm
by eddu
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
Posted: Fri May 12, 2006 8:46 pm
by Janschenkel
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.
And on Mac??
Posted: Sat May 13, 2006 2:56 pm
by eddu
And what if you are on mac?
Posted: Sun May 14, 2006 6:40 am
by Janschenkel
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.