Hi all, kind of new to Access, but I'm learning as I go.
What I'm currently trying to do is take data from an Excel spreadsheet
and transfer it into an Access database with mutiple linked tables. The
catch is, columns from the one spreadsheet are spread out over all 6 of
my linked tables. e.g. 2 columns go to 2 fields in table A, another
column goes to a field in table B, 2 more go to 2 fields in table
C...etc.
I can import the whole spreadsheet as a new table, but I can't figure
out how to propagate the fields between tables the way I want. I'm
stumped.