Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
king1984
Starting Member
4 Posts |
 Posted - 2009-01-12 : 00:56:34
|
| hi everyone... i need help.. i got a database which is using centura sql... i want to convert the centura sql data to xls... can anyone suggest me a way to convert it??i used sqltalk to extract the data... then save the output as txt..when i open the file, the columns are not in the right place... not properly in their column... the data goes to next column.. so.. is there any other options for me?? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-01-12 : 01:26:05
|
| Do you even have SQL Server installed? If you've got the client tools, then you can use SSIS/DTS by specifying the Centura SQLBase driver for one connection and the XLS driver for the other connection.I haven't used Centura SQLBase in about 7 years, so I'm a bit rusty. I don't think they have any kind of business intelligence tool. I remember using their export function, but it didn't provide the features that we have in SQL Server such as SSIS and DTS.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
king1984
Starting Member
4 Posts |
Posted - 2009-01-12 : 05:05:15
|
| tq tara... i will try this one.. actually i dont have sql server... i jz got the database file.. so, i think i have to install it since i get this idea from u... tq tara.. if u have other idea also quite helpfull.. |
|
|
|
|
|
|
how to convert centura to xls??? plizz..