Re: HELP - Import/Export Advice Needed

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