ODBC link to a spreadsheet

[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

[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.

[eddu]

And what if you are on mac?

[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.