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 |
|
ssweeney
Starting Member
3 Posts |
 Posted - 2007-08-14 : 13:24:14
|
| Can someone describe their favorite way of importing access files into sql server? |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 13:30:11
|
| DTS is simple or right click on any table or database select import data from the all tasksclick next and select microsoft access as the source and then select the destinationu can even save this for future use.Ashley Rhodes |
 |
|
|
ssweeney
Starting Member
3 Posts |
Posted - 2007-08-14 : 14:10:13
|
| Thanks. Is there a way to automate this procedure? Or should i automate from access side using upsizing feature?thanks again.Shawn |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-08-14 : 14:38:44
|
| Use the solution given above. |
|
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-14 : 15:13:46
|
| you can create the DTS package and then schedule it as a job to run at any intervals you want it to.Ashley Rhodes |
|
|
|
|
|
|
importing data from access