Modifying the database by parsing a text file

[Sen7inel]

Hi,

I have invoices with ID numbers in SQL DB, and a file (plain text) from bank in certain format with some of those IDs. How to get Access to mark certain bills as paid, accordingly to the text file? I have no idea where to start. Does this need "advanced" VBA programming?

 

[THoey]

I think you can get around the advanced VB programming by importing the text file to a temporary table and then running an UPDATE query from that temp table against your invoice table.

Hope that is a start... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.