Recent content by 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

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