Append Query Question

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

My database stores survey data. The data comes in on an
excel spreadsheet. Some of the data on the spreadseet is
listed below:

[Claim#]
[ClaimInfo1]
[ClaimInfo2]
[ClaimInfo3]
[InjuryCode1]
[InjuryCode2]
[InjuryCode3]
....

There can be anywhere from 1 to 25 Injury Codes.

I have a table [tblSurvey] that stores all the Claim
information, except InjuryCodes, where the [Claim#] is the
primary key.

Another table [tblInjuriesperClaim] stores the Claim# and
InjuryCodes associated with the claim. The combination of
the [Claim#] and [InjuryCode] is the primary keys on that
table.

Can I use an Append Query to add separate records to the
[tblInjuriesperClaim] table. The number of records will
depend on the number of injury codes but all will have the
same claim number.

I hope this makes sense. Please let me know if it does
not.

Thank you,
Grace
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I usually create a VBA macro in the Excel worksheet to read each row
of data and use DAO to run action queries (INSERT) to transfer the
data to my Access tables. The reason I say this is because the data
in your Excel s/s is not Normalized. You could link from Access to
the s/s & run some union queries or other queries to get the s/s data
into your Normalized production tables.

My Excel macro just loops thru each s/s Row in the data range until
the current Row doesn't have any data.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDOy1YechKqOuFEgEQIorACdGCdh4fsRSJDNuBkS/TltJgMF4X8AoMVD
AgqtNdgCLBWc3IrPvZJlQDEc
=dK0T
-----END PGP SIGNATURE-----
 
Back
Top