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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-06-30 : 09:05:24
|
| Boss want me to improve one Access project to prepare data. He want all processing steps running at SQL server.In previous Access mdb file, there are many temp tables, linked tables with SQL server via odbc and many queries such as update, append queries.Can someone give an idea how to run all steps in SQL server, especially how to use temp tables? |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-06-30 : 09:21:01
|
| You mean migration process |
 |
|
|
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2009-06-30 : 09:38:54
|
| Not exactly.Not only data but including all processing steps. |
|
|
|
|
|
|
Prepare data