End of File for Excel?

[cougartrace]

Hi everyone,

We have an excel spreadsheet that we are importing into SQL Server. How can we tell excel that we have 724 rows in the sheet and there is no more after that. When we do the import, we believe it is also taking the blanks fields after 724.

Thanks,

CougarTrace

 

[xlbo]

Shouldn't take blank records unless you have formats or formulas in them.
Try clearing all formats form all cells under your last row of data. Save the file and try again

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

CougarTrace,

I'd try to grab the Excel Sheet with a query rather than import, if SQL Server has the ability to do so.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}