Importing Excel Spreadsheet as Object problem

[cwhite23]

Help!

I'm trying to link an Excel spreadsheet into an Access Report as an object. I can link the spreadsheet but unfortunately, it doesn't import completely. I only get about half of the spreadsheet. Does anyone know what might be causing this or how to fix it?

Thanks.

 

[M8KWR]

you need to check the excel file and see which row is causing the issue, sometimes if you have a blank row inbetween other the rows after do not import.

If does sound like the excel file is causing this

Hope this helps.

 

[cwhite23]

Thanks! Found and solved the problem thanks to you!