How do I insert data from an Access db to a empty SQL database

Hi,

I'm new to VS2005 (vb.net) and here my situation

I have form with a dataset1 (tbl1, tbl2, tbl3, tbl4) pulling data from a Access db. and showing it on the form1(databound)

I need to write what is on form1 to the empty dataset2 in SQL 2005 db

I have created a new DB in SQL 2005 with a Table SQL1 which has the same fields as on form1. Please can some one show me how do I do this. Please

Thanks in advance for your response.

-NM

You can use the Export functionality of Access.

See this post for details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295865&SiteID=1

|||

Thanks, Will do

-NM

How do I get SQL Server integrated into VS2005?

I've had VS2005 installed for quite some time but I just purchansed SQL Server 2005 Developer and installed it. How do I accomplish integeration with SQL Server 2005 to VS2005? I had C# express at one point and SQL Express with the full tool install. That provided me with a designer for SQL Server (which was simply VS2005) and a seperate development environment under C# express. How do I integerate them so all the functionality resides within VS2005?

Any help you can provide will be much appreciated.

Thanks,

Dane R. Vinson

In Visual Studio, open the Server Explorer window.

Connect to your SQL Server.

You 'should' then be able to use Server Explorer in VS to write and test your SQL code.