SQL Server data

sourceuno · Post by **sourceuno** » Mon May 07, 2001 4:45 pm

Is there a way to import SQL Server data into Texis?

ebenezer.maninang · Post by **ebenezer.maninang** » Tue Jul 10, 2001 8:47 pm

Using the SQL export data function (using Texis ODBC driver to convert SQL data to Texis db) worked for the Customers table in the sample Northwind database but not for the Employees table.

I noticed that SQL DTS (Data Transformation Service) changes the SQL 'datetime' data type to 'longvarchar' data type. I then edited it to 'date' data type. However an error still occurs and can't proceed to converting the table.

Any suggestions?