Importing xls and validating before copy to live

[Jordan2000]

I'am working on a existing Database in Access 97

and me was asked to build a Import function fore this database.
The importing function is not the problem and this is already working.

No i'am strugeling to get the validation of this data.

Whe have a Excisting form where whe manual enter the data and need to add more information than is availble on the import excel file.

So after importing 1 file to the temp import table, We need to validate the import. I am thinking about creating a new form with a import list and the old form. and when the usser dubbelcliks on the validated import rule. it's copy's itselfd to the old form so whe can add more information.

Maybe this is posible on a diferent way but I can't find it.

I tried to keep this as clear as posible.

If there are more questions pleas let me know.

 

[The_Doc_Man]

Conceptually, I think you are going in a reasonable direction. Since you cannot directly import to your final table, you MUST bring the data to an intermediate point. From there you can make changes to your records before committing them to their final resting place. I cannot fault your idea. Therefore, if you have problems, you must be having one or more problems in the implementation phase of this project. That is not unusual, either.

First, some very general - but I think valid - advice. Remember Julius Caesar and the Gallic wars. Divide and conquer. Works every time. In specific to this class of problem, break up your idea into steps. Attack the steps one at a time. If the step appears to be too big, break IT up into steps. Break your problems apart until each piece is manageable. NEVER try to attack a problem like this as a single piece.

Second, you can build more than one form in a database. If you import your data to a holding table, you can build a form specific to that table and not related to your final data form. You don't need to doubleclick anything. You can just open the validation form and see the fields in the holding table. If you need to add data, you can do it from there.

Third, when importing data with separate pre-validation, sometimes it is a good idea to allow for cases that can't be solved right away. So perhaps when you are ready to do your update, you can make it selective for those holding-table entries that have been validate, perhaps by checking for some field you KNOW will never be blank in a validated record. You can use that field as the selector (in a WHERE clause) for the append query to tack your new info onto your main table. In that case, you can validate records a bunch at a time and come back to the difficult records later.

Be sure that if you take this approach, you go back and delete those records in the holding table that were appended to your main table. A delete query with the same selector as that append query would do the job for you, I think. That way, you won't try to append the same record twice.

Finally, it seems to me that English must not be your primary language. Don't let that worry you. This is not the first time we have tried to help persons for whom English was not a comfortable language. If you have any trouble understanding what I tell you (or what anyone else tells you, for that matter), it is OK to ask for the same answer another way if you can be specific about what parts you did not understand.