Migrating StarOffice spreadsheet data to SQL Server -- sql server (alternate)

mau_cadi NO[at]SPAM hotmail.com
4/29/2004 10:23:22 PM

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?

Allan Mitchell
4/30/2004 6:47:49 AM

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/staroffice/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

[quoted text, click to view]

sql server (alternate) : Migrating StarOffice spreadsheet data to SQL Server