Hi
I have a .csv file to import - it's correctly formatted and contains all the data VALUES I need.
However, like a good boy, I have designed my access tables IDs - primary/foreign keys to other tables.
So for example, I have a database that manages sports fixtures
I want to import a csv of all the new fixtures for this season
My csv contains Values like:
Date, Home Team, Away Team, Time, Pitch
23/09/2019, Cambridge 1st XI, Oxford 1st XI, 13:00, The Sportsground
but my Access Table has
Date
HomeTeamID (which then looks up another 'Teams' table based on the ID)
OppoID (which then looks up another 'Clubs' table based on the ID)
Time
PitchID (which then looks up another 'Pitches' table based on the ID)
So in short...I can't import my data, because the csv does not have these IDs
Anyway to solve this?
Thanks
I have a .csv file to import - it's correctly formatted and contains all the data VALUES I need.
However, like a good boy, I have designed my access tables IDs - primary/foreign keys to other tables.
So for example, I have a database that manages sports fixtures
I want to import a csv of all the new fixtures for this season
My csv contains Values like:
Date, Home Team, Away Team, Time, Pitch
23/09/2019, Cambridge 1st XI, Oxford 1st XI, 13:00, The Sportsground
but my Access Table has
Date
HomeTeamID (which then looks up another 'Teams' table based on the ID)
OppoID (which then looks up another 'Clubs' table based on the ID)
Time
PitchID (which then looks up another 'Pitches' table based on the ID)
So in short...I can't import my data, because the csv does not have these IDs
Anyway to solve this?
Thanks