Post reply

DTS Lotus 123 workbooks to SQL table

  • August 21, 2003 at 11:46 am

    #151910

    Has anyone created a DTS package directly importing a Lotus *.123 workbook into MS SQL2000 without an intermediate conversion? And if so how?

  • August 25, 2003 at 8:14 am

    #471236

    I never did this but I guess if you have an OLEDB Provider to access Lotus 123, it shouldn't be a problem using DTS to import the workbook.


    Joseph

  • August 25, 2003 at 8:37 am

    #471242

    I agree fromnaija it's just that I have not seen how to set one up to access Lotus 123 anywhere. I have looked for ODBC drivers on the Lotus site as well but I feel that this is not the first time that this has come up and that there must be a simpler solution short of converting multiple spreadsheets to Excel workbooks with named ranges or text files using DDF files.

    But, I may be wrong.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply