Access Imports Blank Validation Cells from Excel

[StephenB]

Hello,

I have an Excel file that I use to enter data. About half the columns are validation cells to minimize human error. The validation cells are in rows 2-200. I then import the data into Access.

The problem is that, even if I only enter or select data in one row, Access imports all 200 rows that contain validation cells. I only want the rows in which I've actually entered/selected data to be imported.

I've searched this forum, but may not be using the correct search criteria.
I've also searched Google for "Access Imports Blank Validation Cells from Excel" and other variations of the same words, and switched empty for "blank".

Can someone recommend a thread or on-line article that will give me an idea how to work around this?

Thanks in advance for any assistance.

PS. Sorry, I wasn't sure under which category to post this.
Again, thanks for your time.

 

[vodafrog]

You could create a named range in the Excel spreadsheet that contains the required data, and then import this only. Normally Acess will import the whole worksheet, this is the reason why your validation cells are also being imported.

 

[ajetrumpet]

I only want the rows in which I've actually entered/selected data to be imported.

Stephen,
You can also drag and drop selected cells or ranges from Excel to Access. It's just like importing....

To copy your selections, you can hold the CTRL key down and point your mouse to an edge of the selection.

 

[neileg]

You seem to be confusing rows and columns. When you import from Excel, rows become records and columns become fields. The import wizard allows you to skip columns that you don't want to become fields in Access. As has already been said, the import routine will default to importing all rows to become records.