Hi all,
A customer wants to retrieve data directly from the Topspeed Database from Microsoft Excel.
I once purchased the Topspeed ODBC driver (2006!) but never used it. I have installed the Topspeed ODBC on a Windows 11 64bit machine. Create a data source and everything looks fine. But now …
How te create the connect string for this data source ?
Regards,
Henk Ouwejan
I’ve never used it, but it should all be in the help files somewhere
As Sean said, I recommend going through the help.
You need to create an ODBC 32-bit DSN entry. Here’s an example. This includes the path to the TPS files.
DSN, Rick, not DNS 
As you say, 32-bit. So one needs to use the instance of odbcad32.exe that’s in c:\windows\syswow64
But it sounds as if Henk has done that. Not at my machine now, but there’s a menu item (on the Data tab?) in Excel that lets you select the DSN.
Edited to add Excel screenshots.
If Henk has the enterprise version of clarion, the developer odbc copy will install, and Ive used that to copy all the settings onto the target computer.
Hi Jane,
The ODBC installation is going fine. The odbcad32 is installed. I created the data source called TestBase at DSN-user and DSN-system. So far so good.
Then in Excel the first 2 steps also works fine but my DSN (TestBase) is not listed in “Choose the ODBC datasource”. That’s where I get stuck.
Any idea?
My Data Source
Ummmm… if you’re using 64-bit Excel you have a problem.
Or, wait for Clarion 12b which will be available before the end of “the year”.
Edit: I guess you could convert your data to MSSQL that would allow both apps to access the data? May as well convert the Access system to use it too?
Hi Jane,
Thank you for the answer.
The good news is. The customer is using a 32-bit version of Excel. So it must be working at their office 
(Lucky me)
Regards,
Henk
Lucky is good! 
Cheers
