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 |
|
miyav
Starting Member
4 Posts |
 Posted - 2003-08-09 : 15:07:51
|
Hi,I have an Access database (mdb) and I have to convert it to SQL SERVER database format. So I have searched that how I can do it, I found some ways useful but I must import tables into SQL SERVER programatically (for example using Visual Basic or SQL Code). Is there any source for this  ?Thanks. |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-09 : 15:21:43
|
| I've never done this myself, but look into the DTS wizard of Enterprise Manger which comes with SQL 2000.Sam |
 |
|
|
miyav
Starting Member
4 Posts |
Posted - 2003-08-09 : 15:37:45
|
| ok. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-09 : 15:41:32
|
| Also take a look here:http://www.sqldts.com/ |
|
|
|
miyav
Starting Member
4 Posts |
Posted - 2003-08-10 : 08:35:47
|
| thank you.the main problem was the identity column. I couldn't do bulkimport from access database to sql server but I have found in this article I need :http://www.sqldts.com/default.aspx?6,107,293,7,1 |
|
|
|
|
|
|
Using DTS programatically