TPorter2 |
Awesome Administrator |
|
|
Joined: 30 Jun 2006 |
Posts: 334 |
Location: Addison, TX |
|
|
|
|
|
|
|
I am posting this resolution just in case it helps anybody else.
Was running a SQL Query for email addresses entered in the last month and then outputting the results to Excel.
Excel showed the first two rows of results and then skipped about 50 rows. Tried lots of different fixes with no success. Finally went to the email address in the row where the problem started. Someone had entered a name in quote marks and enclosed parenthesis marks inside of that. I stripped that out and the output to Excel worked fine.
To be accurate, Excel didn't skip rows, it just clumped all of the data from the 50 rows in one row. Anyway, problem solved! |
|