First, let me say that I'm not a database expert or programmer, so hopefully there is a relatively easy solution to my problem. Ideally there is an off-the-shelf program or process that can solve this problem. Thanks for your help in advance.
Description: About 12 years ago a flat file table was created and stored in .db format. This was a single table database with about 100,000 records. At the time, the .db format was chosen at the time for portability and efficiency. The SQL Anywhere engine allows quick searching and it has performed extremely well.
The problem: I need to dump all of the records from this table into another database --preferably MS Access to start with. I'll be moving them into a permanent home in a spatial RDMS in the near future (The records contain latitude and longitude information).
Unfortunately, I cannot find easy way to get this done. The ODBC driver for SQL Anywhere 5 was 16 bit at the time, and I can't find a 32 bit driver.
How would you suggest I get this done? Attached are a couple of screenshots. Thanks again.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.