filter transfertext action

[Guest]

I have a database whose table data receives updates from external, csv text
files. This database tracks student attendance information at our continuous
enrolment, alternative high school (read: too many many-to-many
relationships!!!)

My problem is administration would like me to develop a second database that
tracks coop placement information (read: different information and for only a
small cross-section of the school's total enrolment!)

The author of the text files is not in a position to write a second series
of scripts for the new database, so what I need to do is "filter" if you
will, the exsisting text files, for the coop database, to have them only
import those records where students, teachers, courses and enrolments that
are coops.

The text files update the attendance database tables by way of a series of
transfertext actions (one for each text file) in a macro.

All coop course codes, unlike any other, all end in a 7 or an 8.

Is there any way I can add to the transfertext actions to filter all course
codes except those that end in a 7 or an 8?

Or am I missing an all together simpler way of getting the job done?

I hope this all makes sense and I have provided enough information! Thanks
in advance for any advice or suggestions.

 

[Ken Snell \(MVP\)]

You cannot filter during the TransferText operation.

Instead, import the entire text file into a temporary table, then use an
append query to filter out the unneeded records and to copy the needed
records into the permanent table, then delete the records from the temporary
table.

 

[Guest]

Thanks for your reply, Ken.

Yeah. That's kind of what I thought I might have to do.