Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing flat file (a2002)

    I need to import about 150 records from a flat file (in either Excel or Access) into 3 separate tables. The data is registration information pulled from another system. The files include information that goes into the contacts table, the company table and the registration table. Does anyone have a process that works well that they would recommend?

    Elizabeth

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Importing flat file (a2002)

    Import the flat file into Access (File/Get External Data/Import...), then try Tools/Analyze/Table. The wizard will probably propose to split the table; you can tweak it manually to get exactly what you want.

    If that doesn't help, provide some detail on the intended structure - how are Contacts, Company and Registration to be related?

Posting Permissions

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