If using ASP scripts remember to convert all your dates

#[date]# to '{date]' or the bald {date]

Frank
----- Original Message -----
From: "Mike Taylor" <lonewolf(at)one.net>
To: "Brett Errington" <brett(at)opensearch.com>
Cc: "'Klaas De Waele'" <klaas(at)gracegraphics.be>; <hwg-techniques(at)hwg.org>
Sent: Thursday, October 25, 2001 11:54 AM
Subject: RE: ASP - converting to SQL server


> I don't even think you have to go that far:  SQL Server's Data
> Transformation Services allows you to import an Access table as is.  DTS
> is accessible via the SQL Enterprise Manger application.
>
> Mike
>
>
> On Thu, 25 Oct 2001, Brett Errington wrote:
>
> > I've never done it... but I understand that it's not too difficult. One
> > method I know you could do (off the top of my head) is to export your
> > access db (it has numerous export functions) to something like a tabbed
> > text file or something that you have read that SQL can import. Just read
> > the help on both and find out what Access can export that SQL will
> > import. This is of course if you don't find a direct conversion
> > function/program.
> >
> > Later,
> > Mr Brett
> >
> > "That's a pain that will surely linger, and that's no lie"
> > - Ed Grimely
> >
> > -----Original Message-----
> > From: owner-hwg-techniques(at)hwg.org [mailto:owner-hwg-techniques(at)hwg.org]
> > On Behalf Of rudy
> > Sent: Thursday, 25 October 2001 8:53 PM
> > To: Klaas De Waele; hwg-techniques(at)hwg.org
> > Subject: Re: ASP - converting to SQL server
> >
> > > Just swap out ourfile.mdb with whatever.sql and change the pointers?
> >
> > hi kayjey
> >
> > nope, that would be too simple!!
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlma
> > g99
> > /html/steps.asp
> >
> > http://support.microsoft.com/support/kb/articles/Q237/9/80.ASP
> >
> > rudy
> >
> >
> >
> >
> >
>

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA