I am an Access newbie and I have a general question.
I have a large Excel file with multiple overlapping sheets that is too hard to maintain, so I want to convert to Access. I have designed my Access tables and populated a little data manually. But now I want to dump all that Excel data into Access. I'm not clear about the best way to go about doing that. The thing I'm stumbling over is the foreign keys. My tables have autonumber primary keys, and most of my tables have foreign keys, but of course my Excel data doesn't have such database keys.
So here is my basic question. Is there someway to import from Excel where Access figures out where to put everything or figures out how to replace the Excel data with foreign keys where needed? Or am I better off creating a tabular form that I can copy paste the Excel data into?
Thanks!