Hi everyone,
I need to import a flat database (excel) of 10 columns to an existing Access database, linked with relationships, though contains no data
so far. It was initially set up with Excel but now needs to be ported
to a safer and more stable platform. It now contains about 70k rows.
I think I need to import it row by row because as I'm importing I need to
drop the data into its corresponding table then get the id then
enter some of remaining data into another table and do that couple times
into another table.
I looked into doing this with queries or series of queries but couldn't
figure it out. So should I do this with VBA? or are there another ways?
Any help would be appreciated. Thanks.