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?

Post by **John** » Mon May 07, 2001 5:49 pm

You could either use the ODBC driver for Texis to load the data into Texis, or you could export the data from SQL Server in a format that can be imported by timport, such as CSV or XML.

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?

Post by **John** » Wed Jul 11, 2001 10:38 am

The 'date' type in Texis and the 'datetime' in MS-SQL may support different ranges of dates. You could try using a field of type varchar(10) if you are just storing the date portion as '2001-07-11' for example, or varchar(17) if including the time as well.