>I need to append records to a SQL table from an Access database using ADO.
>Any help on how to start is appreciated. Any good examples that can show me something similar?.

Can you use the Import feature of SQL Server?

Another way is to open 2 connections (1 for the Access db and 1 for SQL), do a loop to read your Access table and use the INSERT INTO query to insert data into SQL.