Import Data in Microsoft Access

Import Data
By Richard Rost

11 months ago

Fantastic Video Upload Images Link
Scott Axton
11 months ago

Super useful - Both regular and extended.  I was a professional mailer in my previous life (20 years) and fixed length was a pain!

Off topic slightly? ( I remembered the question I was going to ask thanks to this video.)

Example: Say I have an import file in Excel.  Standard fields:  Name, address, phone, email, etc.

My db is set up with relational tables similar to ABCD.
EntityT, PhoneT, EmailT.  Is it possible (feasible ?) to import a record and split the data out to individual related tables with one pass?

If not, how can I update the import table first to reflect the 'new' ID or Code to make subsequent imports relate properly?

Have you addressed this and I'm not finding it?

Juan C Rivera
11 months ago

This is Awesome, Richard get out of my head.... I was thinking about this just last week.
Thank You Maestro.

Richard Rost
11 months ago

Juan: LOL

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.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to Import Data Comments