Giive me examples

1 Oct 2005 4:11 PM

Bpk. Adi Wira Kusuma

I use Ms. Access 2000.
Can you give me examples, how to export 123 to Access use DTS? I

1 Oct 2005 4:34 PM

MeanOldDBA

Have a look at http://www.sqldts.com/.

There should be plenty of information to help you there.

Also, what is "123"?

--
MeanOldDBA
derricklegg***@hotmail.com
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.

Show quote

"Bpk. Adi Wira Kusuma" wrote:

> I use Ms. Access 2000.
> Can you give me examples, how to export 123 to Access use DTS? I
>
>
>

1 Oct 2005 4:55 PM

David Portas

Access can import directly from Lotus 1-2-3, although the success of that
may depend on the version you have and the format of the data. Select: File,
Get External Data, Import on the Access menu.

You may get more help in an Access group rather than a SQL Server one.

--
David Portas
SQL Server MVP
--

Show quote

"Bpk. Adi Wira Kusuma" <adi_wira_kus***@yahoo.com.sg> wrote in message
news:%23dREOMqxFHA.3556@TK2MSFTNGP12.phx.gbl...
>I use Ms. Access 2000.
> Can you give me examples, how to export 123 to Access use DTS? I
>
>