Alpha Video Training
Results 1 to 2 of 2

Thread: importing to a4 v3 from the Web order in ASCII

  1. #1
    abe kravetz
    Guest

    Default importing to a4 v3 from the Web order in ASCII

    How do I import an ascii file that contains the order info to an existing a4 v3 database??????

  2. #2
    Member
    Real Name
    Steve Pick
    Join Date
    Apr 2000
    Posts
    340

    Default RE: importing to a4 v3 from the Web order in ASCII

    Abe, I only have V6 so don't know if V3 is the same.
    Have you tried the Utility Import route?

    Sometimes when I have a file to convert I use Excel. I am still living with V3 or V4 of Excel and they work fine.
    I open the ASCII file from Excel and everything is in column "A". Then I use the DATA PARSE function on a single line.
    Depending on how the data is organized it may take several attempts to PARSE a line to how you want it.
    Once you have it correct then EDIT, REPEAT PARSE for all the highlighted lines. If there are one or two lines incorrectly PARSED you can undo the PARSE if it doesn't include too many lines and then manually modify the PARSE for those lines not done properly.

    When you have everything fine, set the area of the spreadsheet as a database and save the file as a DBF3 file.

    You can open it up fine in A4 or A5 as a database or table.

    They tell me that higher versions of Excel don't work but I don't know.
    Steve

Similar Threads

  1. Importing ASCII file
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 3
    Last Post: 01-17-2003, 01:54 PM
  2. Importing ascii files
    By James Watson in forum Alpha Five Versions 2 and 3
    Replies: 2
    Last Post: 12-03-2001, 04:48 AM
  3. Importing ascii files
    By James Watson in forum Alpha Five Versions 2 and 3
    Replies: 0
    Last Post: 12-01-2001, 12:00 AM
  4. importing to a4 v3 from the Web order in ASCII
    By abe kravetz in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 03-24-2001, 10:20 AM
  5. Importing ascii file
    By Claudia Copper in forum Alpha Five Versions 2 and 3
    Replies: 4
    Last Post: 08-24-2000, 08:51 AM

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
  •