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?

Posted by casey on October 18, 2000 3:17 PM

you can open wordpad, then open your csv file, delete the extra commas at the top of the file, save as a csv file in wordpad, then import it into access



Posted by thomas venn on October 20, 2000 11:26 AM

While you have only 12 rows of data, you originally had 45 rows, then you deleted or cleared the 33 rows. When this occurs, Excel knows you have "messed around" with the row, and therefore when you try to do an import from Access, it tries to import these blank rows too.

The way to get around this is by Inserting a New Worksheet, then copy only those rows which contain data, and pasting it to the new worksheet. then when you do an import from Access, choose the new worksheet.

Cheers,

thomas