Import DB Watcom

Someone knows as it is possible to read the data contained in a Db Watcom 4.0
in order to import it in a Db Sql?
Thanks from Italy
Carlo
Hi
I believe that Watcom is now owned by Sybase after a series of takeovers and
it formed the basis of their SQL Anywhere product.
If you have an OLE-DB or ODBC driver for this, you can import it into SQL
Server. Watcom does have a unload utility that can be used to create scripts
to re-create the database, but I am not sure if you can dump the data into a
file which can be imported using BCP (which would be an alternative method).
John
John
"Carlo" wrote:

> Someone knows as it is possible to read the data contained in a Db Watcom 4.0
> in order to import it in a Db Sql?
> Thanks from Italy
> Carlo
|||Carlo,
You may want to check with Sybase for an ODBC driver. Sybase bought Watcom
several years ago and renamed it SQL Anywhere.
-- Bill
"Carlo" <Carlo@.discussions.microsoft.com> wrote in message
news:5342C3C7-F120-4092-AB39-68745A9ECC86@.microsoft.com...
> Someone knows as it is possible to read the data contained in a Db Watcom
> 4.0
> in order to import it in a Db Sql?
> Thanks from Italy
> Carlo

Import DB Watcom

Someone knows as it is possible to read the data contained in a Db Watcom 4.
0
in order to import it in a Db Sql?
Thanks from Italy
CarloHi
I believe that Watcom is now owned by Sybase after a series of takeovers and
it formed the basis of their SQL Anywhere product.
If you have an OLE-DB or ODBC driver for this, you can import it into SQL
Server. Watcom does have a unload utility that can be used to create scripts
to re-create the database, but I am not sure if you can dump the data into a
file which can be imported using BCP (which would be an alternative method).
John
John
"Carlo" wrote:

> Someone knows as it is possible to read the data contained in a Db Watcom
4.0
> in order to import it in a Db Sql?
> Thanks from Italy
> Carlo|||Carlo,
You may want to check with Sybase for an ODBC driver. Sybase bought Watcom
several years ago and renamed it SQL Anywhere.
-- Bill
"Carlo" <Carlo@.discussions.microsoft.com> wrote in message
news:5342C3C7-F120-4092-AB39-68745A9ECC86@.microsoft.com...
> Someone knows as it is possible to read the data contained in a Db Watcom
> 4.0
> in order to import it in a Db Sql?
> Thanks from Italy
> Carlo

Import data from Excel?

Hello,

I have an Excel spreadsheet that I am loading data from and I want to prevent SSIS from making assumptions about the data contained within the spreadsheed and to just treat every column as a string (i.e. Unicode string [DT_WSTR]). How is this done?

I know I could do a conversion once the data is loaded, but I am wondering if there is a way to specify this in the Excel Source settings without having to add a Data Conversion task to the Data Flow.

TIA...

As far as I know, this cannot be done. You are allowed to set data types in Flat File Sources and delimit them by a comma, though.

Maybe you could export the excel file to comma delimited and then import as a Flat File.

Just a suggestion,

Mark

https://spaces.msn.com/mgarnerbi

|||

You could experiment with the following settings:

Hkey_Local_Machine/Software/Microsoft/Jet/4.0/Engines/Excel/ImportMixedTypes