UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Importing Data, Access 2007    
 
   
Stuartdab
post Jun 8 2019, 11:53 AM
Post#1



Posts: 34
Joined: 22-November 10



Hi all,

Its been a while since i've done Access etc, doing a friend a favour.
Anyway just after some advice, whats the best way to import this data, i've attached a picture.
Its in excel format and the greyed areas are the Parent record and underneath are the children.
Just trying to save him time at work

Thanks

Stuart

Attached File(s)
Attached File  Data.gif ( 248.33K )Number of downloads: 17
 
Go to the top of the page
 
theDBguy
post Jun 8 2019, 12:16 PM
Post#2


Access Wiki and Forums Moderator
Posts: 76,073
Joined: 19-June 07
From: SunnySandyEggo


Hi Stuart. Not sure about the "best," but one way is to assign the same id to the child rows and then cut and paste the parent rows in another sheet. You can then import each sheet separately into Access.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Jun 8 2019, 12:25 PM
Post#3


UA Admin
Posts: 35,520
Joined: 20-June 02
From: Newcastle, WA


Is this a one-time data migration?

Will it need to be repeated regularly?

If it's one-time perhaps the best approach would be mostly manual, i.e. cut-and-paste and so on.

If it's a regular process to be repeated, it might be worth investing in an import routine with a temp table, parsing queries for the master and child tables, and VBA to run the process.

Which way would be closest to the situation you face?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    23rd August 2019 - 06:41 AM