Scott: I have definitely NOT addressed that. Would probably make for a good lesson. You're right. If you get a "normal" file to import from someone with name, address, phone, email, etc. all baked into one table like a lot of people do, you'd need a way to separate that out into individual tables like ABCD does. I'd say an intermediary table for the import would be needed, then a recordset to run down the loop and split everything off. I'll add this to my list. Not sure if it would make for a good TechHelp video, or just something to include in the ABCD.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.