Alpha Video Training
Results 1 to 3 of 3

Thread: Advice needed on transferring data from flat db

  1. #1
    Member
    Real Name
    Charlain Fondren
    Join Date
    Oct 2002
    Posts
    345

    Default Advice needed on transferring data from flat db

    I'd really appreciate any tips and advice on transferring the data from my old flatfile database into my new relational A5 one.

    In my new A5 application, the member's address information is in a separate table from their other information (they are linked by a member number that is auto-incremented during data entry). How do I handle this in such a way that the correct address(es) will match up with the right member?

    Thanks in advance for any tips & advice!

  2. #2
    "Certified" Alphaholic Scott Emerick's Avatar
    Real Name
    Scott Emerick
    Join Date
    Dec 2000
    Location
    Central Virginia/ North Carolina Border
    Posts
    2,154

    Default RE: Advice needed on transferring data from flat d

    Charlain,

    I'm thinking the cleanest most reliable way to do what you need is to import from your flat file into a A5 table first. Number all your members and then seperate the address data from the info data into your 2 tables using an append or copy operation.

    There might be another way, but that to me is the safest most reliable.

    Lets see what others come up with.

    Scott

  3. #3
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default RE: Advice needed on transferring data from flat d

    Another idea: You could import the member number and name information into the parent table and the member number and address information into the child table. This would create the two tables with the linking field(s) filled in.

Similar Threads

  1. Form Advice Needed .....
    By Rich Hartnett in forum Alpha Five Version 4
    Replies: 19
    Last Post: 01-15-2006, 03:54 AM
  2. Advice/Help on Export needed.
    By PhilD in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-18-2005, 06:53 AM
  3. Advice needed
    By BRIAN GRAY in forum Alpha Five Version 5
    Replies: 8
    Last Post: 01-16-2005, 02:12 AM
  4. Network advice needed
    By Charlain in forum Alpha Five Version 5
    Replies: 6
    Last Post: 06-06-2003, 07:37 AM
  5. Upgrade Advice Needed
    By David LITTLE in forum Alpha Five Version 4
    Replies: 15
    Last Post: 02-15-2001, 12:01 PM

Bookmarks

Posting Permissions

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