Advertisement

08.10.2007 at 02:00AM PDT, ID: 22754088
[x]
Attachment Details

Informix CSV extract conversion to SQL Server 2000

Asked by MiddlesbroughPCT in Informix Database, MS SQL Server, Microsoft Development

Tags: sql, informix, server, csv, 2000

I have a CSV extract of an informix database, I'm wanting to import the data into sql server 2000 along with the table properties.

I do not have access to informix.

I notice I have a syscolumns table the same as I would have in SQL which has a coltype column, however I dont have a systypes table which tells me what data type each number relates to.

does anyone have a conversion table e.g. where I have coltype = 6 in my informix table it tells me what data type that equates to in sql.

also any code that looks at my informix tables and imports them directly into SQL would be appreciated.

ThanksStart Free Trial
[+][-]08.10.2007 at 02:19AM PDT, ID: 19668451

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 03:52AM PDT, ID: 19668739

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 03:55AM PDT, ID: 19668752

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 03:58AM PDT, ID: 19668765

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 04:56AM PDT, ID: 19668978

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 06:59AM PDT, ID: 19669838

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 07:07AM PDT, ID: 19669917

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 07:13AM PDT, ID: 19669971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 07:44AM PDT, ID: 19670260

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 07:49AM PDT, ID: 19670314

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.10.2007 at 08:00AM PDT, ID: 19670417

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Informix Database, MS SQL Server, Microsoft Development
Tags: sql, informix, server, csv, 2000
Sign Up Now!
Solution Provided By: twoboats
Participating Experts: 2
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628