Excel Data and FM Search Function

[jonn89]

Hello,

I am using filemaker pro 9 to enter marks for students, and the mark sheets are supplied as excel spread sheets. Right now I am copying the student number from the spread sheet, and pasting it into the search box, then clicking new, and keep doing that until I have entered all the student numbers, and then I click search. This works fine, but I am sure there is a way to highlight all of the student numbers from excel, and then search them all at once? As in highlighting the whole batch of student ID numbers and searching in filemaker as opposed to individually copying and pasting into the search function...

Also, once I have done this I have to type in the students' marks individually, is there also a similar function which allows all the marks from a spreadsheet to be copied and pasted into Filemaker all at once?

Sorry if this issue has been addressed previously, but I searched and found nothing as I didn't even really know what to search for. Thanks for anyone that can help.

Regards,

Jonn

[comment]

See 'Updating matching records' here:

http://www.filemaker.com/11help/html/import_export.16.11.html#1027964