Importing excel into database with multiple tables (1 Viewer)

JimIke

New member
Local time
Today, 12:19
Joined
Aug 3, 2017
Messages
3
New to access and learning lots. Set up a database with multiple tables. Can data be imported into a table that has a relationships to other tables? Scratching my head..Thanks
 

isladogs

MVP / VIP
Local time
Today, 19:19
Joined
Jan 14, 2017
Messages
18,186
Yes - it is normal for databases to have multiple tables with relationships.

As a general rule it is often easier to link to your Excel file from Access.
You can then create an append query to add new records to your table
Or use an update query to update existing records
 

JimIke

New member
Local time
Today, 12:19
Joined
Aug 3, 2017
Messages
3
Thanks. I will look into that. A bit unclear on the updating and/or appending that way. Access seems powerful enough but somewhat clunky. My knowledge with it has me a bit handicapped.
 

Users who are viewing this thread

Top Bottom