Re: Tab Delimiting (was Re: Excel Spreadsheets)

<giggle>
You go to FILE / IMPORT
<giggle>

Seriously.

Look in the DB program of your choosing, now look at the "file" menu. Right
there next to each other <:-> like best friends, IMPORT and EXPORT.

Importing a delimited file into a BD program is *almost* as easy as
exporting one. The big difference is that (in most cases) you get a sample
of the data (one complete record) and a listing of the fields in your data
base. You simply drag and drop / check or uncheck / select or deselect as
required to match up your existing fields with your (to import) data. When
you are happy, just press the "do it" button, and pray :-).


HTH,
Fuzzy

At 04:27 PM 8/17/00 -0500, Tamara Abbey wrote:
>HUNH?
>
>Actually, I just uploaded a survey script from another source and it saves 
>the results in tab delimited format. O.k., so I have a file called 
>survey.log in my cgi-bin and I can look at the results with my ftp program, 
>but this survey for someone else. And, she would like to have the results 
>in a database (shudder, I'm DB-impaired).
>
>So, I'm finally going to ask -- how does one transfer tab-delimited text 
>files into spreadsheets, and in Shelley's case, back again?
>
>Thank you!
>
>Tamara
>
>At 06:32 PM 8/16/00 -0400, Captain F.M. O'Lary wrote:
>>Hi Shelley,
>>
>>!! Aaaah Haaa !!
>>
>>I have it :-)
>>
>>Because you say: "The target audience are distributors so I at least want
>>to have it viewable in Netscape and MSIE."
>>
>>I have an idea. Excel will export a space (tab) delimited text file.
>>Because you know your audience it should be possible to establish an
>>acceptable viewing format via this delimited export ( for instance in a
>>worst case scenario, aligned columns of data with no header information to
>>identify them). The "audience" should be able to read/print/view it *now
>>matter what browser* they were using. Cool. Updating the page would only
>>take the few seconds it took to spit out another delimited text file . . .
>>cool huh?
>>
>>HTH,
>>Fuzzy.
>>
>>
>>
>>At 12:34 PM 8/16/00 -0700, Shelley Watson wrote:
>> >Good Day (again!)  :)
>> >
>> >Well.......I lied.  I ~thought~ I was previewing the spreadsheet
>> >in Netscape when actually it was MSIE.  I knew it was too good to
>> >be true - Netscape drops the "table lines" and the UPC's are
>> >right up next to the product descriptions while in MSIE it shows
>> >up perfect (like, duh!)  :)  .  I've put a little note on that
>> >the spreadsheets are best viewed in MSIE (sigh) and am going to
>> >upload the files for the time being.  I'll have to redo the
>> >spreadsheet - will probably do that in 1st Page.  The target
>> >audience are distributors so I at least want to have it viewable
>> >in Netscape and MSIE.
>>__________________________________________________________________
>>Captain F.M. O'Lary
>>webmaster(at)canopy.net
>>"Common sense is that layer of prejudices which we acquire before we are
>>sixteen." - Albert Einstein
>>------------------------------------------------------------------
>
__________________________________________________________________
Captain F.M. O'Lary
webmaster(at)canopy.net
"Common sense is that layer of prejudices which we acquire before we are
sixteen." - Albert Einstein
------------------------------------------------------------------

HTML: hwg-basics mailing list archives, maintained by Webmasters @ IWA