I have been asked to write a piece of code to take a local MS Access table and bulk load to the MS SQL table. I have searched for threads, but just can't figure out how to get a SQL statement to recognize the local table.
I have this so far
MyCon.Execute ("INSERT INTO WAREHOUSE.dbo.TABLE1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.