Access import to SQL Server with DTS
From: sorCrer (mike_at_spirit.co.za)
Date: 07/01/04
- Next message: Hari: "Transactions"
- Previous message: Mike P.: "Import Error Cannot parse input data string"
- Next in thread: Mary Chipman: "Re: Access import to SQL Server with DTS"
- Reply: Mary Chipman: "Re: Access import to SQL Server with DTS"
- Messages sorted by: [ date ] [ thread ]
Date: 1 Jul 2004 07:34:16 -0700
Hi Guru's,
I apologise if this has been answered!
I am trying to import an Access mdb file with DTS into SQL Server
2000. I have the following problem.
1) The mdb files vary considerably. Is there a way to import all
tables and fields dynamically?
2) Is there another way to transfer data from Access to SQL without
building queries and transferring line by line.
Caveat: I need to do this programmatically. Basically I have various
users uploading an mdb file and need to import their disparate data
into its own SQL database. So it's web technologies that need to be
used.
Thanks for any and all help!
- Next message: Hari: "Transactions"
- Previous message: Mike P.: "Import Error Cannot parse input data string"
- Next in thread: Mary Chipman: "Re: Access import to SQL Server with DTS"
- Reply: Mary Chipman: "Re: Access import to SQL Server with DTS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
