[AccessD] Editing Records

Hi Tim

How do you get this file? Is it text or comma separated?
It might be faster to parse and clean it when reading it rather than
importing it first.

/gustav


>> We get a file from one of our apps, I import that data into an Access db,
>> that data needs to be validated against our SQL Server.  The data from the
>> SQL Server is unbound, no table links.  I basically send the server a
>> project number, if it returns a record, its valid, if not its an error.  We
>> are checking for errors on project numbers, whether its active etc.  We also
>> use the project number and other data to find information about the project
>> and add that to the record, who it belongs, client, etc.  There is different
>> criteria for each validation.  For each record, I could have anywhere from
>> no changes to 13 changes.