Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ISAM Conversion to VFP table or delimited text file
Message
From
30/08/1999 21:35:07
 
 
To
30/08/1999 18:51:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00259435
Message ID:
00259489
Views:
11
>I have am ISAM file that I need to convert over to a foxpro table, delimited text file, or anything else readable by VFP. Has anyone here worked with ISAM? I'm converting from an old, undocumented system and don't know what the structure is supposed to look like. (
>I just have the files)
>
>Any help is appreciated.
>
>-Rick

Your best bet is probably to write a program to read the ISAM file in sequential mode, write it out as a non-ISAM (physical sequential) file, and go from there. This presumes you have access to the machine where the ISAM file resides, along with the facility to write, compile, and run such a program. Even at that, you would need to know the record size and field definitions. If there is no documentation, you could probably get this information from the source listing for a program that accessed this file.

You didn't say what kind of machine the file is on. If it's a mainframe, then you'll need to be concerned with EBCDIC to ASCII character conversion, as well as potentially incompatible field data formats, such as packed decimal numeric fields. I've done some conversions like this, it's tedious but do-able.
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Reply
Map
View

Click here to load this message in the networking platform