Mailing List Archive


Back to the month index Back to the list index
Anthony Harris (tony@ntech.com)
Mon, 27 Jan 1997 19:59:42 -0600 (CST) 

From: Anthony Harris <tony@ntech.com>
Message-Id: <199701280159.TAA10115@reliant.ntech.com>
Subject: Re: [mSQL] MS-Access to mSQL?
Date: Mon, 27 Jan 1997 19:59:42 -0600 (CST)

>
> At 22:38 27/01/97 +0000, msql-list@bunyip.com wrote:
> >Easier way of getting tab delimited out of access.
> >
> >Just save as tab delimited ( menu option under file ).
> >Well ms calls it comma delimited but tis trivial to fix that ...
> >
> >Resultant file then gets ftped to wherever you like.
> >
>
> This is *the* way to produce a tab delimited text: selecting from the menu.
>
> My fear is that Tab Delimited Text Files are not accepted in the command:
>
> % msql namedatabase < nametabdelimitedfile

You can't do this command with tab delimited. You can ONLY do this with a
file that is filled with mSQL commands followed by '\g'

you need to use msqlimport (or something similar) that sets that
deliminating character to the tab, which is '\t'

-Tony

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!