No. I created the import specification, saved it, but it seems to have a size limitation as to the number of characters per row. Whenever, I try to add the additional fields, it looks like it is accepting them until I go to save. I save, then I go to the screen to finish the import, but the change did not save. I go back into the advance screen, and my changes are gone.
This is what I have found so far. When I initially build the import spec and then save, it is fine. The problem occurs when I want to make a change say by adding an additional field. I add the new field to the import spec, save, go back to finish the import, the change disappears. I go back into the newly saved import spec, the change has disappeared. It will not accept any change to the original import spec. I am using Access 2000 and I'm thinking either I have a corrupted database or we haven't loading all of the releases.
Thanks for replying! I will let you know what I find out.
I had a co-worker try the same scenario on his machine--different database and different import spec. He actually built a new one, saved it, processed the import, came back in, tried to make a change, and it would not accept the change. As soon as you hit the save as button, the changes disappear. I'm thinking we must not have loaded all of the system releases or something.