partial import with transfertext

[hklein]

Hello, I am quite new to access programming, I need now to post my first question. I have to import a text file, which has a structure like this: Id;systemname;username;Name The database contains persons usernames in different systems, if a person have access to both systems, than his name is listed twice, like this Id;HR;username;John Smith Id;Finance;username;John Smith What I need to know is, that after the import, I have a table, in which only those records are stored, where the system is HR. What is the right way of doing this? how do I extend this small code?

 DoCmd.TransferText acLinkDelim, "specification", "tblUsers", "c:\export\users.txt"

Many thanks

[June7]

You only want to import the lines that are HR coded?

Then can't use the TransferText method. Or else remove the lines from table after they are imported. Use a DELETE sql action.

[hklein]

Thank you, I did it on this way.