Powershell script to read from file, find matches, write to Access DB.

I need a PowerShell script to search through a text file containing all of the Snort rules and find the SID’s associated with the SRU update. The matching rule data needs to be parsed and written into the Access database table for that specific SID. The table fields that need to be captured and written are: • Rule Actions • Protocols • SRC IP Addresses • SRC Port Numbers • The Direction Operator • DST IP Addresses • DST Port Numbers • Flow (3 columns) • Flowbits (2 columns) • Reference (up to 30 Columns, if needed)