SMO may be the answer.
Job class seems to be what you need.

Well, you cannot. A Linq statement(query) doesn't inherit IOrderedEnumerable. You can use extension methods OrderBy and OrderByDescending of the type returned by the query(which, if I'm not mistaken, is of type IEnumarable(of T)). These two functions return an IOrderedEnumerable(of T) object.
Example

        If SortAscending Then
            Sorted = (From MusicCard As SongCardNFO In SongCard Select MusicCard).OrderBy(Function(music) music.SetProperty1)

        Else
            Sorted = (From MusicCard As SongCardNFO In SongCard Select MusicCard).OrderByDescending(Function(music) music.SetProperty2)
        End If

put the code in a while -> while not end of file, read a new line

        Dim EeErString() As String
        If EeErTextFieldParser.EndOfData Then
           MessageBox.Show("No records to display.", "End of Data")
        Else 
           while not EeErTextFieldParser.EndOfData
             EeErString = EeErTextFieldParser.ReadFields()
             EmployeeLabel1.Text = EeErString(0)  ' First field.  
             EmployerLabel1.Text = EeErString(1)  ' Second field.
             EmployeeLabel2.Text = EeErString(2)  ' etc
             EmployerLabel2.Text = EeErString(3)
           end while 
        End If

well, do you want to use Excel VBA or VB.NET? If you want VBA , move the question in VB6 section.
For VB.NET:
-create a new Windows Forms Application
- add a button to the form
- double click the button
- write the code

Next step:
- get the path of the Excel file
- use TheKirk's link to read from Excel
- look in tutorial section for a basic example of working with ADO.NET.
- if you get stuck with a piece of code, come back with a question and we will help you from that point.

What assembly does your application uses? If you go to C:\Windows\assembly, probably you will have two versions of System.Data.SqlServerCe: 3.5.1.0 and 4.0.0.0(or whatever version is Ce 4). You said you use the code that worked with VS2010, have you changed the reference to the right assembly? It appears to be a compatibility issue.