Updating Records in a File

[Steve]

I'm wondering what the is the best way (using DAO) to
accomplish this:

Get a file, read into Access, use conditional logic on
various fields, be able to update records in those fields
according to program logic, then write and save to a new
file/table.

Hoping for some guidence on how to accomplish......

 

[John Vinson]

I'm wondering what the is the best way (using DAO) to
accomplish this:

Get a file, read into Access, use conditional logic on
various fields, be able to update records in those fields
according to program logic, then write and save to a new
file/table.

Hoping for some guidence on how to accomplish......

A "file"? as in a comma-separated-values text file, a Table in some
other database, a dBase table, or what?

If it's a text file, I'd use the TransferDatabase method to import it
(assuming that it's in a predictable and orderly format) into a
pre-built Table; run your update queries; and then use
TransferDatabase again to export it back to (the same or a new) text.