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 |
|
sharu_tan
Starting Member
11 Posts |
 Posted - 2003-02-22 : 04:22:30
|
| How to Transfer the data from Access 2000 Table to Sql Server 7.oEdited by - merkin on 02/22/2003 07:25:46 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-02-22 : 09:40:29
|
| DTS?If it's a one-time thing and you are just looking for the easiest and most user friendly way, use the Enterprise Manager.CLick Tools, Data Transformation Services, Import Data.Very straightforward and easy to use.- Jeff |
 |
|
|
sharu_tan
Starting Member
11 Posts |
Posted - 2003-02-24 : 00:15:27
|
Dear Sir thanks for your reply , Actually i will transfer the data from front end tool in Visual Basic 6.0 can i call DTS package from front end . if its possible please send the coding for that. quote:
DTS?If it's a one-time thing and you are just looking for the easiest and most user friendly way, use the Enterprise Manager.CLick Tools, Data Transformation Services, Import Data.Very straightforward and easy to use.- Jeff
|
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-02-24 : 00:50:45
|
| Greetings,You need to use the DTS object model in Visual Basic. so the steps are as follows.1. Write your DTS Package in sql server 2. Use the DTS object model in VB and run the package through VB front end. (References the following in VB - "Microsoft DTSPackage Object Library")PS: I have used the DTS object model in VB, its very easy and handy.. Try it and if u need more help le us know..HTH Samrat |
|
|
|
sharu_tan
Starting Member
11 Posts |
Posted - 2003-03-03 : 01:19:28
|
| Dear Sir Can i pass the paramere to DTS pack. , i have 8 mdb file and all of the file should transfer to SQL Server, can this thing do with single DTS pack. can i send source file name and path to DTS pack through VB 6.if its possible please send that coding. |
|
|
|
|
|
|
Migration Access to Sql server7