pcsoft.us.windevCopyright 2026, PC SOFT30 Jan 2016 18:07:49 Z28 Jan 2016 22:31:04 ZHi Guys, I am having a slight issue with figuring out what is the correct method of doing the equivalent of an Append Query in Access. I have an excel report that I am importing into a table. I have managed to get the Excel File imported into the Database, but I am struggling to figure out how to deal with duplicates if I have to re-import this list due to additions to the original excel report. I had looked to use a separate import table, the to append the new records into the main database without having any duplicates. All the methods for importing excel seem to have issues surrounding the handling of duplicates for what I want to do, by either adding in all the records again & creating a large number of duplicates, or having an error report for every duplicate that is being attempted to be imported. Excel file can contain in excess of 70,000 records & there may be only 1 or 2 additions to this file between imports, however there is no means of identifying just the new records to allow for entry of just these new items. I am using WinDev 20, so have used the HImport]XLS method, but can't seem to figure out the best way of removing the Duplicate information. What is the correct way of doing the equivalent of a Append Query in accessso that I can use a temporary import table, then only add the new records. Similarly, what is the equivalent of the Update Query in Access? The Update query only seems to let me update to a manual entry, unless I am not using it correctly. New to WinDev so easily confused. I have searched through the tutorials & this forum / WinDev online Help, but have not been able to find the information I am after. I am sure there is probably an easy way to do it, but I can't seem to find it for some reason. I have tried importing an access database, but it takes the query in as SQL so does not show me the WinDev way of doing it. Any help appreciated. Steven30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)stevenpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56163/read.awp30 Jan 2016 18:07:49 ZFabrice, Once again, thanks for your help. Will give this a try. Preference would be to do this into the main table, …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56163/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56163/read.awpAppend Table after importfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56159/read.awp30 Jan 2016 01:16:38 ZHi Steven, importing in a first table means slower process. However, once you have your first table (or my text file in me…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56159/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56159/read.awpAppend Table after importstevenpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56131/read.awp29 Jan 2016 13:55:40 ZFabrice, Thanks again for your help. I have managed to import the XLS file into a separate table, but it is the duplicate …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56131/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56131/read.awpAppend Table after importfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56128/read.awp29 Jan 2016 13:13:28 ZHi Steven As I'm not using access, I cannot give you any equivalent method. However to import an xls file, as you requeste…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56128/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56109-append-table-after-import-56128/read.awpAppend Table after import