Hi!
I have a csv file called Data.csv that annoyingly contains duplicate records.
So I open up this file, manually delete these duplicate records using the =COUNTIF(A:A,A2) formula (provided row 1 contains headers) then I apply a filter to delete all rows where the COUNTIF formula returns > 1.
Then I save the changes made to the file and close it as DataAmended.csv (still keeping it as a csv).
So nothing has changed apart from removing duplicates and file name.
Now in my access program, when it gets to the code
Code:
DoCmd.TransferText acImportDelim, "Standard Output", "tbl_Security", "C:\Txtfiles\DataAmended.csv"
a table called tbl_Security gets created but when I open it, it is empty!!
But when I point the above code to the original file Data.csv i.e.
Code:
DoCmd.TransferText acImportDelim, "Standard Output", "tbl_Security", "C:\Txtfiles\Data.csv"
a table called tbl_Security gets created and when I open it, it is not empty
Any advice please?
Thanks!