Re: HELP - Import/Export Advice Needed
Date: 1995/07/27
Message-ID: <3v7r2o$gcc_at_pubxfer2.news.psi.net>#1/1
Probably SET LINESIZE to some BIG number would help.
as360512_at_orion.yorku.ca (Manny Pires) wrote:
>On 21 Jul 1995 13:41:44 GMT, you wrote:
>>>>The simplest solution would be to do create a delimited flat-file. I
>>think access will take either tab-delimited or comma-separated-values.
>>To create such a file try something like this...
>>SET FEEDBACK OFF
>>SET HEADING OFF
>>SPOOL mytable.csv
>>SELECT '"'||fname||'","'||lname||'","'||phone||'"'
>>FROM mytable
>>/
>>SPOOL off
> Thanks for the help. The solution did work except for fields in
>my SELECT statement which were of the LONG format. For some reason,
>the flat-file truncated the information. Is there any way of
>preventing that from happening?
>Manny
Received on Thu Jul 27 1995 - 00:00:00 CEST