Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: goingkraze
- Order by date
-
Append MS SQL table from MS Access table
I used the link table to refresh. It is a little slow, but this is only a interim solution until I can get the formal DTS in place. Thanks AlexCuse for you help.- goingkraze
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Append MS SQL table from MS Access table
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...- goingkraze
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
API Call to find out the Network Name of the computer running the DB
I was trying to get this code to work, but it seems to be missing two functions. Do you have the code for ChkusrRec and EditUsrRec? It is calling these in the ReadldbUsers section. Thanks for any assistance. This seems to be exactly the code I have been looking for for a while.- goingkraze
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
