Recent content by jfgervais69

I tried to set an example of VBA code but I still have a compile error in this line ****. Can you help me please? where tmpPRODBR : My temporary table tblPBRUT : My existing table Dim db As Database Dim rs, rs2 As Recordset i = 0 tmp = 0 Set db = CurrentDb() 'Set rs =...

I forgot! How to program this loop to read all records from the temporary table and insert them into the table if the record does not exist or update if it exists and first in this loop of course, remove all empty records ?? In a While loop? For? What is the equivalent of an EOF for a table?

Thank you very much for your response and your help. However, I still have another question for you. How can I compare all records in the temporary table to all in the table that I want to update? How do I program the loop to pass all the records? Thank again

I put an attachment an example of a CSV file. I put the name of fields, the sames I used in the table ACCESS, on the first line of this file. The fields is integer or floating or just text.

A new record should be included in the table when the pNumber is not present, because it is the primary key of my table. If pNumber exists, then it is necessary to check if all values are the same. If so, do nothing and skip to another record in the CSV file, otherwise change the value of the...

yes, my CSV file is always is the same format, fieds space by tab : Example : PSEQ PNUMERO PCODE PDESC PDIM PMAT

I would like updating existing table in ACCESS, with CSV file automatically using VBA code, but I do not know how because I only bases knowledges in VBA programmation . I do not want to create a new table every time, I want the record to be added to the existing table if they are not present...