Swisher, Timothy B.
tswisher at GFNET.com
Wed Mar 5 10:14:01 CST 2003
It is already in an access table. I get about 3-4 thousand records in a text file, but a large portion is already in a table. Tim -----Original Message----- From: Gustav Brock [mailto:gustav at cactus.dk] Sent: Wednesday, March 05, 2003 10:59 AM To: Seth Galitzer Subject: Re: [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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com