Re: Loading an Excel work***...

On 11 May 2007 02:25:19 -0700, The Frog
<andrew.hogendijk@xxxxxxxxxxxx> wrote:

The closest you can get to that is Access' import wizard. Import
specifications can be setup and saved for a later day. It's a far cry
from DTS, but so is the price of Access versus SQL Server...
Heck if you REALLY wanted to, Access can be setup as a linked server
for SQL Server; then you CAN use DTS to do your ETL work.

There may be some generic ODBC-based packages to suit your needs.

-Tom.



Hi Tom,

ETL is Extraction, Transformation and Loading. It is a term used
usually for database tools and processes. As an example SQL Server
2000's DTS is an ETL type tool.

The Frog

.

Loading