|
Home > Archive > MS SQL Server DTS > September 2005 > Lotus 1-2-3 Connection
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Lotus 1-2-3 Connection
|
|
|
| Dear all,
Appreciate if anyone can share experience on connecting directly to Lotus
1-2-3 files through DTS.
Currently I am using SQL Server 2000, and would like to connect to *.123
files (Lotus SmartSuite 9.8).
Thanks in advance.
| |
| Michael Cheng [MSFT] 2005-09-26, 3:23 am |
| Hi CCT,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to know whether you
could use Lotus 1-2-3 files directly in the DTS file. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, we do not have a Lotus 1-2-3 files driver in the SQL
Server directly. However, you may try NotesSQL in the www.lotus.com
creating ODBC connectivity.
You may also export the data in 1-2-3 files into Excel file and link the
Excel file in the SQL Server directly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|
|