[Year 12 Its] off topic (a little) sharing data between databasesand spreadsheets

[Robert Timmer-Arends]

Rob

when you import does the import wizard fire up? If so you should get to
specify the column data format for each column (step 3 of my version)
I don't know id this helps but I've had similar thing with student CASES
codes where, for example, MAR04 becomes 4th March

Regards
Robert T-A

----- Original Message -----
From: "Rob Attrill" <attrill.robert.j at edumail.vic.gov.au>
To: "IS List" <is at fhc.vic.edu.au>
Sent: Monday, May 16, 2005 2:34 PM
Subject: [Year 12 Its] off topic (a little) sharing data between
databasesand spreadsheets


> Sort of off topic but this seems the most likely place to get an answer.
>
> Why would an excel  spreadsheet which receives data in a .txt file from
> a database correctly import data such as 11B, 11C, 12B or 12C, but
> stubbornly receive 11A as .485333333 and 12A as 0? It is clearly
> importing it in a numeric form despite all attempts to format the
> receiving cells as text. Obviously, I can find plenty of "can do" fixes
> (using an apostraphe to precede the data, etc), but the issue itself is
> bugging me.
>
> regards
> Rob Attrill
> Mill Park Secondary College
> _______________________________________________
> http://www.edulists.com.au
> IT Systems Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
Association Inc