Re: Want to Load Data MS Access Sql Server 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "David Portas" <REMOVE_BEFORE_REPLYING_dportas@xxxxxxx>
Date: Mon, 1 Aug 2005 22:31:21 +0100

Why load the data into Access, clean up the data and then load it back to
SQL Server? Assuming there is some logical reason have you tried using the
Import/Export Wizard? That's perhaps the easiest way to get started with
DTS.

--
David Portas
SQL Server MVP
--

.

Follow-Ups:
- Re: Want to Load Data MS Access Sql Server 2000
  - From: Mike Moore

References:
- Want to Load Data MS Access Sql Server 2000
  - From: Mike Moore

Prev by Date: Want to Load Data MS Access Sql Server 2000
Next by Date: Re: Renaming all DTS pacakges on a server
Previous by thread: Want to Load Data MS Access Sql Server 2000
Next by thread: Re: Want to Load Data MS Access Sql Server 2000
Index(es):
- Date
- Thread

Relevant Pages

Re: Access Form connected to SQL table in Access Data Project (.adp file)
... simply bad design to open up a form to a HUGE table, ... You can use what is called the "where" clause. ... the form what records it should load. ... we are NOT even using sql server yet. ...
(microsoft.public.access.conversion)
Re: Profiling error message 208: sorting the wheat from the chaff
... Profile load to a file then load the> file to a table or have Proviler load to a table directly. ... > SQL Server MVP ...
(microsoft.public.sqlserver.server)
Re: Access Form connected to SQL table in Access Data Project (.adp file)
... Under the previous design, he would just open the form and could ... navigate through the last few orders by clicking "next record" a few times. ... > the form what records it should load. ... we are NOT even using sql server yet. ...
(microsoft.public.access.conversion)
Re: Importing data into MS-SQL from AcuCobol
... how you are loading the data. ... - Look into using DTS in SQL Server. ... not used it with AcuODBC, ... > interface to load the data. ...
(comp.lang.cobol)
Re: Dealing with Web Mining on Apache Log
... I found an MSDN entry showing how to use SQL DTS to load web log ... files to your SQL Server data warehouse. ... The other two are more sequence analysis problems. ... >> mining the apache log file for my final year project. ...
(microsoft.public.sqlserver.dts)