Splitting an Import Table

Giganews Newsgroups
Subject: Splitting an Import Table
Posted by:  noodnutt (noodnu…@gmail.com)
Date: Sun, 16 Feb 2020

Hi Team

Apologies for the lengthy post, just felt I needed to clearly outline what it is I need to do.

Was hoping someone could assist with the best Update Query approach.

I have 44 fields of data importing, anywhere from 1 to 100 rows of data, multiple times a day.

I have tblImport fields labelled as F1 to F44 and needs to be split into 4 tables.

Essentially, my question is, where to add the Auto PK, and how to copy this to 3 additional tables.

As always, many thanks for any assistance.

Cheers
Mark.

tblJobs
anfRecordID = PK ( AutoNumber )
dtfDate = AutoDateStamp
lnfAccCode = Long          ( F1 )
txfDepotCode = Text        ( F22 )
txfServCode = Text        ( F20 )
txfFileName = Text        ( F44 )

tblJobs_From
lnfRecordID = Long        ( Needs to be copied from PK )
lnfC_AddCode = Long        ( F3 )
txfC_Ref = Text            ( F10 )
txfC_Con = Text            ( F11 )
txfC_Spec = Text          ( F34 )
dtfC_Ready = ShortTime    ( F32 )
dtfC_Prefer = ShortTime    ( F33 )
dtfC_Date = ShortDate      ( F2 )

tblJobs_To
lnfRecordID = Long        ( Needs to be copied from PK )
lnfD_AddCode = Long        ( F3 )
txfD_Ref = Text            ( F10 )
txfD_Con = Text            ( F11 )
txfD_Spec = Text          ( F34 )
dtfD_Time = ShortTime      ( F32 )
dtfD_Prefer = ShortTime    ( F33 )
dtfD_Date = ShortDate      ( F2 )

tblLoads
lnfRecordID = Long        ( Needs to be copied from PK )
txfI_Type = Text          ( F40 )
txfI_Desc = Text          ( F24 )
txfI_Stack = Text          ( F41 )
txfI_DG = Text            ( F42 )
txfI_Class = Text          ( F43 )
dnfI_Qty = Double          ( F25 )
dnfI_Space = Double        ( F26 )
dnfI_Weight = Double      ( F28 )
dnfI_Cube = Double        ( F27 )
dnfI_Height = Double      ( F29 )
dnfI_Length = Double      ( F30 )
dnfI_Width = Double        ( F31 )

Replies