I routinely end up with multi-GB csv's when grabbing a slice of data at work. Excel can handle the first million lines well enough before needing to fire up the data model and power pivot, but even then, SQL is definitely the better tool for the job.

But yes if you're using it where a spreadsheet would do...why you no use spreadsheet?

Reply to this note

Please Login to reply.

Discussion

No replies yet.