Question

1 Oct 2005 5:12 AM

Bpk. Adi Wira Kusuma

Sorry, If I'am wrong in posting my question at here. I ask, If I export data
to text, so I can write like this:

INSERT INTO T1 IN 'C:\'[Text;]
FROM T2

Now, How to export data (LOTUS 123) with Sql in Ms. Access?

Second, is There setup program to install ISAM only?

Third, How to install "Provider=Microsoft.Jet.OLEDB.4.0;"?

1 Oct 2005 10:00 AM

SQL

To insert data into a text file use DTS (Data Transformation Services)
To export 123 to Access also use DTS
To instal the provider get MDAC

http://sqlservercode.blogspot.com/

Show quote

"Bpk. Adi Wira Kusuma" wrote:

> Sorry, If I'am wrong in posting my question at here. I ask, If I export data
> to text, so I can write like this:
>
> INSERT INTO T1 IN 'C:\'[Text;]
> FROM T2
>
> Now, How to export data (LOTUS 123) with Sql in Ms. Access?
>
>
> Second, is There setup program to install ISAM only?
>
> Third, How to install "Provider=Microsoft.Jet.OLEDB.4.0;"?
>
>
>

1 Oct 2005 3:00 PM

John Bell

Hi

It is not clear if this question is anything to do with SQL Server!

You may get a better reply in an access newsgroup;

If you are wanting to export from Access to Lotus 123 the easiest way may be
to use the file/export option to create a file alternatively you can link
the 123 file as a data source and use SQL to insert the values.

John

Show quote

"Bpk. Adi Wira Kusuma" <adi_wira_kus***@yahoo.com.sg> wrote in message
news:OxyQeekxFHA.3124@TK2MSFTNGP12.phx.gbl...
> Sorry, If I'am wrong in posting my question at here. I ask, If I export
> data
> to text, so I can write like this:
>
> INSERT INTO T1 IN 'C:\'[Text;]
> FROM T2
>
> Now, How to export data (LOTUS 123) with Sql in Ms. Access?
>
>
> Second, is There setup program to install ISAM only?
>
> Third, How to install "Provider=Microsoft.Jet.OLEDB.4.0;"?
>
>