Is it possible to import 1 spreadsheet into two tables? I had to split a table into two- one has the call information such as phone number, date, time, sales agent, etc., the other has information about the call such as whether various legal requirements were met. The first table has the primary key as an autonumber and the second table has that as a foreign key w/ a lookup, so that's how they are joined. However, the data that was gathered is on two spreadsheets, that I can either leave separate or combine into one. I'm not sure how I can import this though, and I get a subscript out of range error trying to import the second spreadsheet into the second table. Eventually I will have it set up for a front end/back end type database so the data will go directly into my reporting database, but for now I need to import it. Any ideas on this?