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 |
|
dragonsbb16
Starting Member
3 Posts |
 Posted - 2006-05-18 : 14:50:25
|
| Background.....I have Front End VB6, and Back End Access...Access is mainly a Data Dump...a bunch of tables and data...NO queries, forms etc in Access...just Data and indexesMy Question is....Is the DTS Import Feature supposed to convert Access(including Indexes, Primary Indexs) into SQL Server? B/c as far as i can it is doesnt do that?If so where in SQL Server should I be looking? b/c i must be blind.Thank you in advance...JimSQL Enterprise Manager |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-10 : 16:29:09
|
| I don't think DTS imports anything else than data.In Enterprise Manager you can right click the table and select design table. After that it looks almost as Access.Peter LarssonHelsingborg, Sweden |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-10 : 16:46:38
|
| Are you looking for the upsize wizard under tools, database utilities in access?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DTS Import