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 |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2008-04-28 : 12:33:07
|
| Gurus,I just created a new MS-Access(2003) database and I imported the tables from SQL server 2005. What I need is, I want to refresh the MS-Access databse automaticaly twice in everyday.Please any one help me to do this process. It is urgent issueThanks-- Krishna |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-28 : 12:35:13
|
| I think one method will be creating a job which calls a ssis package which will synchronise the tables in access db to be consistent with sql server. |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2008-04-28 : 12:37:04
|
| Visakh, Thanks for the quick reply. Can you guide me to do this with SSIS packages..?Thanks-- Krishna |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-28 : 22:13:36
|
| Did you read books online for that? |
|
|
|
|
|
|
SQL to Ms Access