2 Replies Latest reply: Mar 14, 2012 7:40 PM by Joe Kirwan RSS

    LOAD v SQL SELECT

    Joe Kirwan

      Up to now, I have been mainly dealing with table files.

       

      So I use the LOAD command, then specify the individual fields I want to load.

       

      I can also append calculated fields, and change the formatting of fields in the script following LOAD.

       

      Now, I want to connect to a MS Access file.

       

      Using the wizard, firstly I connect via ODBC to the Access file; then I click on the Select button.

       

      It enters the script

       

      SQL SELECT *
      FROM Table

       

      The problem is that I don;t know how to do the things I do with the LOAD command, such as selecting indivdual fields rather than all (*), or changing the format of individual fields, or appending fields during load.

       

      Can anyone help?

       

      Ta

       

      Joe