Alpha Video Training
Results 1 to 2 of 2

Thread: Suggestions required on how to proceed with a prob

  1. #1
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default Suggestions required on how to proceed with a prob

    I want to be able to import 240 Excel V.4 files into a Adb and then append them all to the same table.
    Easy enough if all XLS files had exactly the same column names.
    The Table in the ADB has 24 fields. The Excel files will only have some but not all of the field names as column names.
    Can this exercise be achieved without having to either update 240 Excel sheets or define 240 differnet import & append Operations?

    I am running A5 Home edition Version Build 1506 and System addins build 1058.

    Any Guidance welcomed.

  2. #2
    Member
    Real Name
    Bill Warner
    Join Date
    Apr 2000
    Posts
    905

    Default RE: Suggestions required on how to proceed with a

    If you had the full version, instead of the home edition, you could probably create an Xbasic script to do this. It would take some work, but would be preferable to creating 240 operations. I believe you could get credit for what you paid on the home edition if you upgraded to the full version (although don't quote me on that).

    If the Excel files aren't real large, would it be feasible to cut and paste into a larger Excel, and then import?

Similar Threads

  1. Query prob, None defined
    By dchiass in forum Alpha Five Version 5
    Replies: 6
    Last Post: 10-28-2004, 10:56 AM
  2. Required-now not required, Problem
    By Leslie Blades in forum Alpha Five Version 5
    Replies: 6
    Last Post: 05-19-2003, 06:27 AM
  3. unsure of how to proceed...
    By martin robert in forum Alpha Five Version 5
    Replies: 6
    Last Post: 05-07-2003, 08:44 AM
  4. Dialer Prob
    By Scott Emerick in forum Alpha Five Version 4
    Replies: 2
    Last Post: 08-17-2002, 06:17 AM
  5. Xbasic for Everyone prob
    By Wanda Tucker in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-11-2002, 06:33 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
  •