Import into subform

[MarcusAntonius]

I have a form, A, with a subform B. Form A contains details on software and subform B lists the machines the software is installed on. I currently add a machine manually to the subform B. If I had 40 machines, how can I do this automatically?

 

[MarcusAntonius]

Basically I have a list of 40 MAC addresses in a csv file, and what I want to do is import them into the subform instead of entering each MAC address manually. I want to be able to do this with Form A open so that I can see which to which piece of software I am adding the list of MAC addresses.

 

[MarcusAntonius]

Sorry, but how do I link to the csv file?

 

[MarcusAntonius]

When I create this append query and run it, I get the message

'you are about to append 0 row(s)'.

even though the file contains about 10 records.

(I have attached a screenshot of the append design. The data table is the imported list of MAC addresses - 10 of them)