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
Printable View
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
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.
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
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.
Yes, I have a webinterface based on ASP
But I have to code it in VB.