Insert into Acces table

[a_michael]

how to insert a sql 2000 table into access table using vb ?

[MAK]

1. TWO adodc - one pointing to sql server another access. then you can loop through the dataset and insert it into access

2. create link in access to sql server table and insert into access using insert