seashore67
Technical User
Is there any way to automate an import of an sql server database...therefore creating an update of those tables?
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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automate an import of an sql
- Thread starter seashore67
- Start date
- Status
I am alittle unsure of what you are asking... Are you trying to link the sql database to access? If so trying creating a system ODBC connection (Control panel - Administrive Tools - ODBC Connections) and then pointing it to your server and database. Then in your database you would simply link (File - Get External data - Link tables) the tables via the ODBC connection. That way you are pulling live data from the server to the database. You can then build your forms, queries, reports, etc. using the linked tables. If this isn't what you are looking for then please post more info!
If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations
If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations
- Thread starter
- #3
seashore67
Technical User
Hi
Yes I was trying to link and as I further read into what i was doing i figured that out. Thanks for the help though.
Yes I was trying to link and as I further read into what i was doing i figured that out. Thanks for the help though.
- Status
Similar threads
- Locked
- Question
- Locked
- Question