Dynamically Insert single record into MS access from SQL server

view full story

http://serverfault.com – I have two databases(SQlserver and MS Access) with same schemas (same tables). SQL server database has data but Access has no data (blank database). My goal : when user enters a ClientId and click insert button then I need to retrive that single record from all tables in sql server database and insert into tables in MS Access Database. Achieved: i retrived from all tables in sql server databases with client id and stored the data in Dataset. Problem: Insert into Access tables???? i have table array and i am looping thru all tables in array and trying to insert data from above dataset into (HowTos)