Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Importing meeting schedules from Access

Topic Labels: Data
138 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jweaver
4 - Data Explorer
4 - Data Explorer

Hello there,

I'm starting to migrate from an old Access database to Airtable.  Part of this Access DB was used to track a number of groups and the days/times they meet per week.

The data is in two tables, Groups and Meetings.  Groups is just a list of groups which has a one-to-many relationship with Meetings which is a matrix of a time-of-day and day-of-week:

Screenshot 2025-01-16 at 9.37.56 PM.png

Screenshot 2025-01-16 at 9.38.47 PM.png

It shows in a report like below.  The letters in the boxes are different meeting formats:

Screenshot 2025-01-16 at 9.48.05 PM.png

I have imported the data into AT and linked the two tables.  The issue is that all of the time-of-day and day-of-week data is getting combined into fields.  I understand that is what is supposed to happen.  Is there any way to link records and keep them separated in a one-to-many relation?

Here is a link to a Base with the sample data: https://airtable.com/applQ22GX9Mh4QaAI/shraUgGlLA5zlOKoi

Thank you for any insight you may be able to provide!

Jason

1 Reply 1

Hmm, not sure I'm following what you want the outcome to be.  Could you have a look at the screenshots below and tell me what data might be missing?  In your report, does that only show the upcoming week or something?

Screenshot 2025-01-26 at 12.05.51 PM.png

Screenshot 2025-01-26 at 12.05.48 PM.png

Screenshot 2025-01-26 at 12.05.44 PM.png

Link to base