Hi

Looking for some advice and maybe an example.

basically I have an Access Database that im opening into a datatable in VB

I then want to save this data into a SQL table. Now there are roughly 80,000 records in this table, and this will need ot be done fortnightly.

I can't just move the access db over to SQL as im not allowed

Is there an easy way of doing this from VB? as this is going to run as part of a bigger process. I know It could be done using import feature in sql but the person that will be running this won't have access to sql

thanks in advance