Importing Data and updateing Fields

[ajolson1964]

I want to import data from a txt file and update fields within a table. More specifically what I am looking to do is have the txt file open then evaluate each record within a table to match a unique identifier. When the match is made I want the “Empty (null)” fields within that file to be updated and those fields that are not null to be ignored. Is this at all possible? And if so does anyone have the code that will help me execute this.

 

[SeeThru]

You might be easier coding to:

Import the table
Use filtered recordsets to identify the reocrds, make the changes
Export the table as text in the same format with the changes, overwriting the file.

Won't work if the text file is shared or already open.

SeeThru
Synergy Connections Ltd - Telemarketing Services

http://www.synergyconnections.co.uk