Alpha Video Training
Results 1 to 4 of 4

Thread: Import Excel Data?

  1. #1
    Member rpaulson's Avatar
    Real Name
    Ross
    Join Date
    Sep 2007
    Location
    NW Ohio
    Posts
    33

    Default Import Excel Data?

    Hello all,

    I am new to Alpha. Using A5V5.

    I have a table in my database. I have about 15 records that I entered by hand. I have some more records (about 50) in an excel file that I wish to import.

    Every time I go through the import wizard alpha wants to create a "new" table in my database.

    How can I get there records imported into my table with the original 15 records?

    Tia,

    Ross

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Import Excel Data?

    The import genie offers me the choice of new or existing table.

    You could just save the excel file as a dbf and append to your existing table.

  3. #3
    Member rpaulson's Avatar
    Real Name
    Ross
    Join Date
    Sep 2007
    Location
    NW Ohio
    Posts
    33

    Default Re: Import Excel Data?

    I have version 5. It does not appear to have the import option to an existing table.

    I did import it into a new table then I open the table - selected all the records - selected copy records and pasted them into the existing table.

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Import Excel Data?

    Genie works the same for me in V5

Similar Threads

  1. How do I import from Excel?
    By Barb Deleon in forum Alpha Five Version 8
    Replies: 16
    Last Post: 10-17-2008, 12:04 PM
  2. import data from excel from web
    By David Brown in forum Application Server Version 8
    Replies: 1
    Last Post: 12-09-2007, 06:05 PM
  3. Import excel data / Filter Grid component
    By thetalent_one in forum Archived Wishlist
    Replies: 0
    Last Post: 09-13-2007, 04:14 AM
  4. Import data from excel
    By Christine Hembrow in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-23-2004, 01:40 PM
  5. Import Excel DB
    By Michael Vermouth in forum Alpha Five Version 5
    Replies: 2
    Last Post: 12-19-2003, 12:29 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
  •