Lotus to MS SQL Server 2000 - VB Programming

[Kaleb]

Hi There

I have a Lotus-spreadsheet and I want to import it in MS SQL server 2000 tables - using DTS packets made in VB. Its an online application...!

Does anyone know how it can be done or have some documentation about it.

Best Regards

Kaleb

[MAK]

Why you need to VB to fire a DTS. Instead you can use VB to import lotus spreadsheet to sql server.

DATA component can read lotus files
and ADO can write to SQL Server.

[Kaleb]

But I cant find any documentation...

And it has to be DTS packets kommunicating with the SQL server.

A person needs to be able to do this online from a website. Lotus -> SQLserver

[MAK]

1. when you say ONLINE does that mean you have a web interface? If YES then what platform? (ASP/PHP/JAVA)

2. Why it has to be a DTS? I dont think you can directly import lotus files using DTS. Some activex should help.

[Kaleb]

Yes, I have a webinterface based on ASP

But I have to code it in VB.