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.

 All Forums
 Other Forums
 MS Access
 i want move data from Access to SQL server

Author  Topic 

sql000
Starting Member

3 Posts

Posted - 2002-09-15 : 03:45:34
i want move data from Access to SQL server
i need code semple for vb.net


<edit> moved to proper forum </edit>

Edited by - robvolk on 09/15/2002 09:30:49

VyasKN
SQL Server MVP &amp; SQLTeam MVY

313 Posts

Posted - 2002-09-15 : 05:36:45
There is an Access Upsizer that can migrate Access databases to SQL Server. Search Microsoft site for the download.

You could also use DTS to transfer data from Access to SQL Server.

Another option is to create a linked server from SQL Server to Access and for reading data.

Sorry, I don't have a VB.NET sample.

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-09-15 : 09:33:16
quote:

<edit> moved to proper forum </edit>

Edited by - robvolk on 09/15/2002 09:30:49



Sniped! I was just about to do that!

Damian
Go to Top of Page
   

- Advertisement -