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

 

[Pat Hartman]

There is no option to exclude blank rows. If you can create a range that excludes them, you can import just the range.

 

[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

 

[Pat Hartman]

An alternative is to import all the rows and then run a delete query to delete the empty rows.

 

[ghudson]

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