Re: Queston about Access

["Hans-Joachim Leidinger" <hans-joachim.leidinger@home.gelsen-net.de>]

******    message to minivend-users from "Hans-Joachim Leidinger" <hans-joachim.leidinger@home.gelsen-net.de>     ******

I use Access! That is my way:
1) i have some fields like code, price, display, comment, etc
2) Some column / field is a memo-field, to get more text (i.e.
description with more than 255 characters)
3) mark each column and click the right mouse-button, rename this column
to i.e. "price" etc.
4) export this database as "txt", choose TAB without Qoutation mark ""
and choose the column-name as the first row with the fields-name
You get i.e. a product.txt with TAB between each fields without
Qoutation mark "" !

I have no problem with this way, but there is a different between UNIX
and DOS/WIN!
In Unix, all row has "^M" at the end of line (returncode)!
Look for the two files "unix2dos.exe" and "dos2unix.exe" via websearch
(i do not know exactly the adress), who convert your files for win and
UNIX!

I hope, this can help you!

Joachim


>******    message to minivend-users from "Jeff Nappi"
<brage@phear.cyberhighway.net>     ******
>> ******    message to minivend-users from Jerry Bransom
<jbransom@pcpc.data1.com>     ******
>> > I'm currently using Excel for my database-files, but I'm not happy
with it.
>> > Can you tell me, how exactly you go from an Access-database to a
database
>> > useable for Minivend ?
>> >
>> > Thanks a lot in advance,
>> >
>> > -Gideon van Gelder
>> >
>
> I use MySQL for the minivend database and use access with the MyODBC
>mysql odbc driver for linux to interface with real time, it works very
well.
>
>good luck
>
>--
>___________________
>Jeff Nappi
>brage@cyberhighway.net http://phear.cyberhighway.net
>Cyberhighway Internet Services Network Operations Center
>-
>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
>

-
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