RE: exporting to .csv file

What is the secret to making MS Query work consistently?  It locked up more
than half the time I've tried to use it.  The Excel add in that comes with
Client Access works a bit better, but generally gives up when I specify any
selection criteria less inclusive than *. 

> -----Original Message-----
> From: Pete Hall [mailto:pbhall@execpc.com]
> Sent: Friday, July 23, 1999 12:44 AM
> To: MIDRANGE-L@midrange.com
> Subject: Re: exporting to .csv file
> 
> 
> At 12:14 07/22/1999 , Alan Novick wrote:
> >I'm trying to export an AS/400 physical file to a comma separated
> >variable file in a folder so I can email the data to someone who can
> >open the file in Excel.  Right now I am doing it in two steps.
> >
> ... SNIP...
> >Is there an easier/better way to do this?
> 
> Since the desired end result is an Excel spreadsheet anyway, 
> why not just
> send one? That's what I usually do. The following procedure is pretty
> close, but I don't have access to the current version of Excel or the
> AS/400 at the moment, so this is from memory.
> 
>   1. In Excel, Open menu data | get external data | create a 
> new query.
>   2. Specify or create an appropriate ODBC datasource when prompted.
>   3. open SQL view (or use the GUI query builder if you like)
>   4. create a query like "SELECT * FROM MYFILE"
>   5. File | Return data to Excel
>   6. Back in Excel, File | Send To | Email recipient
> 
> Note this procedure does require that you are able to connect to your
> AS/400 via ODBC. If you haven't already built a datasource, 
> you can do so
> as part of the process. Excel and MSQuery insists on using a "file"
> datasource, so you may end up duplicating a system or user 
> datasource name.
> This doesn't seem to cause problems.
> 
> 
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---