import data into linked table

[ShaunBlake]

I’m building a database for my books and I’m at a crossroads: have the library set up with genre; media type; media; and authors. Authors, genre, and type are populated and now I realize I don’t know how to get the media in.
My choices seem to be:

• Set up a sheet with the auto-generated Author_ID assigned to each ‘book’
• Start over with a hodgepodge sheet and split it into the appropriate tables in Base
• Create a macro to import each ‘book’, associated with the author

I listed the macro last because it is the most daunting/intimidating.

Any advice would be welcomed. Thanks for reading!

[Ratslinger]

Hello,

This has some confusing points.

You state you are building a database (base) but title reflects ‘import data’ and details talk of ‘sheets’. Also there is nothing about what the end result is supposed to be - your goal.

Also not certain what this really means:

…have the library set up with genre; media type; media; and authors.

Are these separate tables? Is there supposedly a relationship among them?

Please edit you question with additional information.