Access to SQL Server - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access to SQL Server

Carlos Cavazos

6 years ago

Hi Richard. My next project is to have Access be able to update a Table in SQL in real time. This is how i'm accomplishing this right now. Everything is done in Access 2016. In my query I have all the fields needed. I do an export text file from that query. I'm using SQL Server Agent to import my last csv file on a schedule and is set to every 30 minutes. Is it possible to accomplish this task directly from Access. If so, can you tell which videos I can purchase?

	Richard Rost @Reply 6 years ago
You should be able to connect Access directly to the SQL Server table as a linked table. Once that's done, you should be able to treat it like any normal Access table. Database Tools > External Data > From Database > SQL Server

	Juan C Rivera @Reply 6 years ago
Richard, good day to yo I like to see this can you do a tech help and show how to 1 do a simple table, 2 link, and a long shot move a picture on to a file location like you did with the Genealogy database. Shout out to Alex I love the flags. Live long and prosper V/r Juan

	Richard Rost @Reply 6 years ago
I don't currently have SQL Server set up in my office, so that will have to wait. Moving a file is something I will add to the list. A few people have asked me about that. But you've got the Seminar, so just use that. :)

	Juan C Rivera @Reply 6 years ago
Richard thanks for the quick response. I will play around and see what kind of things do with SQL express Live long and prosper V/r Juan

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View