Whilst I have never done it I note that Q40 here mentions an ODBC driver
(amongst others) for Star Office
http://wwws.sun.com/software/star/st...e/faq.html#1q8
If that is the case then I suppose you could use DTS or anything else that
will plug into one of the drivers mentioned in the FAQ.
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals -
http://www.sqlpass.org
"AleC" <ma******@hotmail.com> wrote in message
news:2c**************************@posting.google.c om...
Hi
I need to import data from StarOffice 5.2 spreadsheets to a
Datawarehouse built in SQL Server and I wan to know what is the best
way to do it. I think I have the next options:
- Create a java app using StarOffice api
- Use StarOffice Automation (I'm not shure if its possible in version
5.2)
Is this right?
Exist some ODBC driver for *.sdc files?
Exist other option?
Which option is the most recommended?
Thanks