Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
happy1001
Starting Member
4 Posts |
 Posted - 2015-04-22 : 16:42:54
|
| I have got 4 MS Access Database Files, which have got 3 Tables each, means Total 12 Tables which gets updated with new data every evening, by an external application. Means new data gets appended to all these 12 Tables.I want to have exact same 4 Databases, which have got 3 Tables each, means Total 12 Tables, but WITHIN MS SQL SERVER. And then update all of these 12 Tables every evening, with the corresponding updates from the respective tables from the MS Access Databases.Please suggest me the various options to get this kind of work done in SQL Server. I do not want to Manually Update all these 12 tables every evening into SQL Server. Hopefully there would be some easier method to do this in automatic manner.Thanks a lot for any ideas. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-22 : 18:06:06
|
| Can the external application be run twice so that it updates both Access and SQL Server?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
happy1001
Starting Member
4 Posts |
Posted - 2015-04-23 : 01:18:10
|
quote:
Originally posted by tkizer
Can the external application be run twice so that it updates both Access and SQL Server?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
Thanks for your reply tkizer.No, there is no way to update the SQL Server with that application. The data will get updated only into Access Database and we need to find a way to get that into SQL Server from there. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2015-04-23 : 01:46:40
|
| Can you not run a batch script - for example - using powershell , that connects to one and moves data across? Or use SSIS to pull the data?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Access to SQL Server - Auto Update Multiple Tables