Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert an Access table to SQL Server table programatically

Status
Not open for further replies.

dropspun

Programmer
May 2, 2001
12
0
0
US
I'm new to ASP.NET. Does anyone have any tips on how to convert a Microsoft Access table into an SQL Server table in code-behind? I know there's got to be a way. I've gotten as far as getting an Accessdatasource and an SQLDataSource, but there my knowledge stops.
 
Why would you want to do this in the code-behind? If you are going to upgrade a database, then it should be done on the database server side, even if you are just doing one table for testing.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top