Tag Archives: software

Select a range of records from a dataset in T-SQL

This is a way to filter out a numbered range using T-SQL.  I.e. if you wanted to select the 100th – 110th row from your dataset. Firstly use the OVER statement to add row numbers (as ROW_NUM column) to your … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Importing Selected Data From csv File into Excel using VBA & ADO

I use this approach when I need to import only selected records or fields into Excel from a csv file. This requires that you add a reference Microsoft Active Data Objects to support the ADO code. The idea is to … Continue reading

Posted in Programming | Tagged , , , , , | Leave a comment