I have a database called Employee on a remote SQL server.
The database has a table called CompTime.

I need to know how I can access the data on the CompTime table using VB. I have an ODBC drive to conned to the SQL Server(called TEST) and userid: sa, password: blank.

Could someone help me with the code to connect and access the data from the database.

Thank you.