how to autoupdate an access database from a sql database
I have an access database that I built. I want to try and automate the data entry. I have a sql database that auto discovers new data. How can I automatically import at least part of the data from my SQL database into my access database.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Can you explain the relationship between the SQL database and the Access database?
ASKER
there is not a relationship right now. the sql database is a monitoring database that monitors my network. I have other data that I entered into the access database that my monitoring does not have. So I was hoping to import some of it from my sql databse into access
does creating a linked table from the sql database not an option ?
ASKER
that sounds ok to me. I'm trying to connect to it now. It's solarwinds and I'm not sure if it was setup with sql or sql express. I'm assuming the database is on the same server. I'm conected to the server via vpn and using a different login when I rdp to the server because it's in a different domain
Then I would investigate the "Linking" technique the other Experts suggested.
If exact timing is an issue, then investigate a manual "Refresh" system.
Or adjust the settings that affect this: (see attached screenshot)
JeffCoachman
untitled.JPG
If exact timing is an issue, then investigate a manual "Refresh" system.
Or adjust the settings that affect this: (see attached screenshot)
JeffCoachman
untitled.JPG
ASKER
I created a linked table and I pulled data over. What I would really like for it to do would be to only import 2 columns into an already existing table appending data since some of the values will already be there. How do I do that?
This seems like a new issue, ...separate from your original issue.
If your original issue is now resolved, please accept the Post(s) that help solve this specific issue.
Then post this new concern as a new question.
;-)
JeffCoachman
If your original issue is now resolved, please accept the Post(s) that help solve this specific issue.
Then post this new concern as a new question.
;-)
JeffCoachman
That is a brief article for exporting data from SQL database to Access through a function.
It may include more than what you need, however it does provide code.
Alternatively, you could use a stored procedure / trigger combination.