Data Problem

[Jeff Hoffman]

Bob

At 09:31 AM 04-06-01 -0500, you wrote:
>G'day mate
>
>I didn't know that Access couldn't output to a CSV file.  

You can export as a txt file, however this creates pretty formating:

------------------------------------------------------------------------
| Advanced Surgical Technologies              | AD002                  |
| Test st. Sydeny                             |                        |
|                                             |                        |
|                                             |                        |
|                                             |                        |
|                                             |                        |
------------------------------------------------------------------------
| Advanced Surgical Technologies              | AD003                  |
|                                             |                        |
|                                             |                        |
|                                             |                        |
|                                             |                        |
|                                             |                        |
------------------------------------------------------------------------

and you can loose data, as it will only output the data displayed on the
screen. In the above example I had all the lines displayed, when I forgot
to expand the boxes I got:

------------------------------------------------------------------------
| Advanced Surgical Technologies              | AD002                  |
------------------------------------------------------------------------

also when I expanded the boxes to get all the data, my 3mb access db
expanded to over 26mb.

I could not see any option to output a csv file. (also by data has embedded
commas as well).

>What would be
>better is a fixed record length file, which can be done from Excel when
>saving as a .PRN file.  

There are limitations with .PRN due to the amount of data to be exported.

>You can then transfer this file from the PC to the
>VMS box.  Most tools such as Reflection will translate the CR/LF and EOL
>characters to RMS format for you; it's in the settings.
>
>Create a dummy subfile with Quiz with fields that match what's in the .prn
>file.  You may have to add an extra one char dummy field at the end of the
>record.  Delete the subfile.SF file and copy the myfile.PRN file to
>subfile.SF.  Then try and read the file with Quiz.
>
>Good luck.
>
>Blue
>
>PS. a good editor for performing bulk changes in the ascii file is TextPad
>(www.textpad.com).  It has a lot of useful features and a good macro tool.

An even better one, for VI lovers, is at www.winvi.de/en/

I can make the txt option work, but only as a last resort.

Thanks

Jeff

>
>-----Original Message-----
>From: Jeff Hoffman [mailto:wonicon@bigpond.net.au]
>Sent: Sunday, June 03, 2001 2:11 AM
>To: powerh-l@lists.swau.edu
>Subject: Data Problem
>
>
>Hi
>
>I have received an access (.mdb) data base, I need to create a tab
>delimited file for processing by QTP.
>
>The data has line feeds (hex 0a) embedded in the data. Record separator is
>cr/lf (hex 0d0a). Powerhouse is treating the line feeds as a record
>separator.
>
>The powerhouse is running on a VMS system.
>
>As far as I know I use access to create an excel spreadsheet, then use
>excel to create the tab delimited file, which is transferred to the VMS
>machine.
>
>Does anybody know if the line feed can be converted to say ", " without
>affecting the record separator in any of the steps? or any other
>suggestions.
>

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                          + e-mail: wonicon@bigpond.net.au    +
+ Director                              +                                   +
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\    +
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2232              +   fax: +61 2 9521 3979  \_,-._*   +
+ AUSTRALIA                             + mobile: 040 790 3929         v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+