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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 access to sql conversion

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-12-17 : 11:26:40
Brett writes "Im a wed designer and quite new to sql 7. Recently we made a dynamic web site which used a sql 7 database. The databse was outsourced and created by a programming company for us. The database has three main tables it uses for the web site. These tables were imported into sql from access.

My question, is there a way just to export the three tables from access into sql. the sql database also contains stored procedures, etc, but I dont need to touch them. Ive look at the upsizing wizard in Access but I dont want to create a completely new sql database as it wont have the stored procedures, I just want to export the three tables.

Basically i need to add records to an exsisting sql database but Im trying to avoid buying a copy of sql developer edition."
   

- Advertisement -