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    
post Jun 8 2019, 11:53 AM

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



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

Access Wiki and Forums Moderator
Posts: 76,064
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
post Jun 8 2019, 12:25 PM

UA Admin
Posts: 35,519
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    22nd August 2019 - 09:22 AM