Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Nov 2005 @ 19:13:35 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Export to a text file using OLE-DB
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, November 30, 2005 09:57 -->

One of the steps of the procedure was:

Click on Settings and enter the name of the output file in the Table name location without any punctuation or special characters (for example, MyOutfile.txt). This name must end in ".txt".


The error message that you got was:

Cannot create table "c:\myoutfile.txt" because: Type is invalid.

This makes it appear that you entered "c:\myoutfile.txt" for the "table" name instead of "myoutfile.txt". You should only enter the filename part of the pathname (for example, "myoutfile.txt") as the "table" name. The folder part of the pathname (for example, "c:\") should be entered into the "Data Source" property when establishing the connection to the Jet provider.

Hoping that it helps you out!



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023