How to convert a vsam file so that we can use it in Access?

[Goot]

One of the ways we use Access is to query DB2 databases via ODBC. One of the tables is quite large


There is a vsam file which needs to be converted prior to our moving the information into Access so we can run queries vs this information.

Does anyone know how to convert a vsam file so that we can use it in Access? The person who used to do this left the firm and we're having difficulty finding a solution.

 

[Blorf]

If you know in advance the structure of the file, you can break it down with some code. vsam supports variable length records, kinda like XML I suppose, so it's not real easy to just do.

There are 3Rd party apps out there that will just do this for you and give you an ODBC link to the data so you can read it in your own format.

I have no idea what they cost. I would google vsam odbc and see what you find.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.