troubleshooting Question

SQL Anywhere 5.5 database flat file: Converting table to Text

Avatar of Matt-W
Matt-W asked on
Microsoft AccessSybase Database
5 Comments1 Solution997 ViewsLast Modified:
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.


screen2.jpg
screen3.jpg
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”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