Search results

Hi CJ_London After some tests in SQL I have decided to do it in VBA!:mad: If you are interested in the VBA code, please send your e-mail address to hela(@)dtu.dk.

Thank you for your answer, but I don't see how to do it. Could you please give details.

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...

Re: Renaming field names in linked database: Problem solved I have for a couple of days been working with other things, but when I returned to the field renaming problem I found an easy way through :-) 1) Copy all queries from Front End to Back End. 2) Back End: Make sure that "Name...

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...

I have followed you method. The linking is fast, but the subsequent Append Query to move data from the linked table to my Access table takes just as much time as my original DoCmd.TransferText in VBA. So I am still looking for something that can considerably speed up things. But thank you...

I am familiar with Linked Tables when linking to another Access database, but how to link to a semicolon delimited text file (with no header row for field names).

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...