Results 1 to 8 of 8

Thread: Convert FOL database

  1. Sep 17th, 2005, 11:42 AM #1
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Convert FOL database

    I've been tasked with writing a utility to convert a FOL database (old DOS format) to some other format (CSV to start out probably).

    I was just curious if anyone else had any experience with this format or if anyone has done this in the past. I'd rather not reinvent the wheel if possible.

    I know it's probably just as simple as opening the file in binary, and digging through the lines taking piece by piece, but I was hoping to find someone here that has dealt with it.

    Thanks in advance for anything.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  2. Sep 17th, 2005, 11:50 AM #2
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Re: Convert FOL database

    Now that I think about it, this may need to be moved to the databases section. If a mod could kindly do so....
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  3. Sep 17th, 2005, 12:24 PM #3
    RobDog888
    RobDog888 is offline
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Convert FOL database

    Moved from Classic VB forum.
    VB/Office Guru™ (AKA: Gangsta Yoda™ ®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    • Reps & Rating Posts • VS.NET on Vista • Multiple .NET Framework Versions • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6
    Reply With Quote Reply With Quote
  4. Sep 21st, 2005, 08:57 AM #4
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Re: Convert FOL database

    *bump* anyone?
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  6. Sep 21st, 2005, 09:30 AM #5
    kaffenils
    kaffenils is offline
    Fanatic Member kaffenils's Avatar
    Join Date
    Apr 2004
    Location
    Norway
    Posts
    946

    Re: Convert FOL database

    Quote Originally Posted by ober0330
    *bump* anyone?
    Sorry, I have no idea what a FOL database is. Searched for it on Google, but didn't find anything.

    I guess you have to go with your idea to open it in a text or hex reader and see if you can get anything usefull out of that.


    Tutorial: SQL Server recursion
    Small ADO demo
    Reply With Quote Reply With Quote
  7. Sep 21st, 2005, 09:43 AM #6
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Convert FOL database

    Try the FILE SYSTEM OBJECT - maybe it will recognize the "delimiter" of each line and make parsing easier. We've had good luck with FSO for converting files from other (non-PC) platforms.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  8. Sep 21st, 2005, 09:47 AM #7
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Convert FOL database

    some info (from yahoo) here

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  9. Sep 21st, 2005, 10:02 AM #8
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    Re: Convert FOL database

    That is awesome Ecniv! It's a wonder I didn't find that when searching.

    And yes, for the others, the database is actually called "First Choice", the the format is FOL.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width