Weird import to Access

[Jockstrap]

I have 300 lines of data in an Excel workbook, but when I copy them over to Access it says I have over 700???

Does anyone have any idea why this could be?

 

[tstumpf]

Do you have any hidden rows that may be getting copied over?

 

[Anne Troy]

Test:

Hit ctrl-home to get to cell A1.
Hit Shift+Ctrl-End to get to the last used cell.

If the selection is beyond your data, then Excel thinks there's stuff in those cells, and so will Access.

To clean it up, see the 4th item under:

http://www.thewordexpert.com/excel.htm#CommonExcelIssues