Import TXT file to database with distinct clause (1 Viewer)

Hi,

i am using this command to load data from csv file:


It is possible to remove duplicated from the file in Access directly?

Best,
Jacek

to remove duplicates you need to import your file to a temporary table, then use a SELECT DISTINCT query to copy the rows to your main table

Alternatively you can use transfertext to link to your file and then use the SELECT DISTINCT query to copy to your main table

To automate further, once you have your linked table, you can copy over the same location as the original file to save creating more linked tables.

e.g. say your files are called

F1.txt
F2.txt

etc

copy the F1 file to a common location and rename it F.txt (use the filecopy command)
now create your linked table to the F.txt file
then run your SELECT DISTINCT query

for F2, all you then need to do is to copy F2 to the common location and rename to F.txt to overwrite the previous file, then run your query again

hi CJ_london,

thank you very much. So i can link only once and only replacing txt files?

Best,
Jacek

that is correct - clearly the text files need to be the same in terms of number of columns, column headings etc.

Try it and see

thank you !

Jacek