blank rows
Posted by Dick B on October 18, 2000 11:08 AM
i am importing an excel(97) spreadsheet into access (97) and am getting blank rows imported. there are 12 rows of data in the spreadsheet. when i import the spreadsheet i get 45 rows of data - 33 of which are blank rows. when i open the spreadsheet and export it as a .csv (comma delimited) file, i get 45 records - 12 of which have data and 33 of which are just commas. what is it in the spreadsheet that is causing this and how do i not import these blank rows?