Search results

  1. H

    Combine several records into one record

    How can I combine several records in a table into one record? Suppose that I have a table like Table1 in the attached image. Then I want to combine all records with the same value for Key1 in one record. The result is shown in Table2 in the attached image. I would prefer to do it using SQL...
  2. H

    Renaming field names in linked database

    I am using a modelling system GAMS that is able to export data to an Access database, my Back-End database. The export facility makes Access tables with field names 'Dim1', Dim2' etc. Therefore I have made a VBA subroutine that changes these field names to something meaningful. But then the...
  3. H

    Importing huge text files

    I have several huge semicolon delimited text files that I import to tables, one table per file. The files are of size 200 - 300 kB and have more than 1,000,000 lines each. My problem is that it takes too much time to do the import. I am importing by using DoCmd.TransferText. (I am aware of my...
Back
Top Bottom