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


    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?