| re: Importing to Access XP from Excel XP
jfall...@depaul.edu wrote:[color=blue]
> 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[/color]
spreadsheet[color=blue]
> and transfer it into an Access database with mutiple linked tables.[/color]
The[color=blue]
> catch is, columns from the one spreadsheet are spread out over all 6[/color]
of[color=blue]
> 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.[/color]
If the spreadsheets share a common value in a column, then you can link
to the spreadsheets and create a query that will put all the info into
a single virtual table. Then you can append that somewhere. It would
be something like this...
SELECT xls1.field1, xls1.field2, xls2.field2
FROM xls1 INNER JOIN xls2 ON xls1.field1=xls2.field1
WHERE...
then once you have that working, just turn it into either a make table
query or an append query and you're good to go.
| 
