macromedia.coldfusion.database_access
[Top] [All Lists]
<prev [Date] next>
Google
 
<prev [Thread] next>

Re: Access to SQL Server

from [paross1]
Subject: Re: Access to SQL Server
From: "paross1" <webforumsuser@xxxxxxxxxxxxxx>
Date: Tue, 11 Sep 2007 15:56:56 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access 

Why don't you just import your Access database into SQL Server using DTS, then 
just delete the data by using TRUNCATE TABLE [i]tablename[/i]? Of course, you 
will have to manually transform any autonumber PK fields in Access to IDENTITY 
fields in SQL Server, and re-create any FK constraints, etc.

 Phil
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: Problem with Join, cf_dev2
Next by Date:  Re: Problem with Join, jjonney
Previous by Thread:  Access to SQL Server, AlwaysWannaLearn
Next by Thread:  Re: Access to SQL Server, AlwaysWannaLearn
Indexes:  [Date] [Thread] [Top] [All Lists]