Re: Excel Database Import Quirk

[Dan Busarow <dan@dpcsys.com>]

******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Fri, 12 Mar 1999, Vic wrote:
> I am using Excel to create a tab-delimited products.asc file.  As noted in
> the documentation, "'s are appended to the beginning and end of each text
> entry.  I have tried changing the catalog.cfg entry to look like:
> 
> Database    products    products.asc    1
> 
> I have also tried:
> 
> Database    products    products.asc    EXCEL    1
> 
> 
> and some other variations on that theme.  After stopping and restarting
> minivend, I still get the "'s at the beginning and end of the text entries.
> Can anyone shed any light on what I might be doing wrong?

Since it's Excel putting the "'s in the file, changing MV settings
isn't likely to fix it :)

Read the Excel file into Access and use Access to export it.  You
can tell Access not to use "'s

Or if you have vi
:.,$s/	"/	/g
1G
:.,$s/"	/	/g

:)

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list