i am trouble transferring spreadsheet from excel to access , it had work fine the first 3 spreadsheet s that i want to transfer to Access. for some reason on spreadsheet contain information for 3 table , for example it contains all the inforamtion i need to put in my costumer table and contact information also my sales representative table. So when i do the process to transfer the tablt into tblcustomer at the end it give me message "subscript out of range ". its been a week no one cant help me with that , anyone had the same problem , i would appreciated it :o

So when i do the process to transfer ...


It will be very difficult to help you without know exactly what you are doing to perform the process.

What are your steps?