Importing blank rows from Excel

[morrisg]

Hi Folks.
As a newbie in Access, but not in Excel, I tried to 'get external data' from an Excel spreadsheet into an existing Access table.
However, it brought in blank rows because those rows had a formula in them but nothing else.
Any way to avoid the blanks being imported??

Many thanks
morrisg

 

[morrisg]

Thanks Pat, I guessed as much.
I worked out a simple 'work around'.....copy and paste the used rows onto Sheet2, then Import Sheet 2 instead of Sheet 1.
Clumsy but it works better than nothing.
Thanks
Morris

 

[ghudson]

Add the "Required" property to your table fields that should have data and that will prevent the empty rows from being imported.