prevent import of empty rows from Excel
Posted on 2008-06-20
I'm using Enterprise Manager to import data from excel into a SQL server table into my database. The import works but the process tends to import extra empty rows from the excel sheet that I do not want. So for example: If my Excel spreadsheet has three rows of data that I want to import, it's actually importing rows 1 thru 4000. What's the easiest way to prevent this. I would prefer not to have to create a custom SQL statement if I can avoid it. I much prefer using the wizard to transfer the information.
Any ideas would be appreciated.