[RESOLVED] Bulk Insert into sql
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