excel-access
 

I am trying to import a excel sheet to a access table. Alot of the data in the excel sheet is pulled from other sheets by links in formulas. The data began by transfering okay but as new data gets added daily in excel some of the new rows began to not transfer over. now all new data that is entered into excel will not transfer to access. I tried data validation and adjust the feild properties in access but no success. help please