Tab Delimited Query

[Guest]

Hi All

There is probably a very simple answer to my query, however been trying for
ages to solve it all to no avail. I have a a Tab Delimited Excel sheet
"data1" using 8 columns and covering nearly 8000 rows -- columns G & H are
numerical and a lot of the cells contain a single zero (0) after using The
Text Import Wizard and changing everything from General to Text and then
saving. When uploading on to the web database as a text file the zero's in
the cells don't display. Using 2007 and in Options enabling - Show a zero in
cells that have a zero value -- still no zero's display. Any help much
appreciated

 

[dan dungan]

Hi Sue,

What is the data type of the field that should show the zeros in the
web database?

Dan Dungan

 

[Guest]

Hi Dan

I'm a bit lost here -- its basically a flat file database using a Perl cgi
script and I have just about filled in all the data in Excel , like I said 8
columns and nearly 8,000 rows and saved it as Tab Delimited and then uploaded
it on to my server as data1 .txt file -- its been a lot of hard work. But it
works OK except for the missing zero's and that spoils the final output.
--
Many Thanks

Sue

Hi Sue,

What is the data type of the field that should show the zeros in the
web database?

Dan Dungan

 

[dan dungan]

works OK except for the missing zero's and that spoils the final output.

Hi Sue,

Are the zeros missing in the text file or does the database remove
the zeros after you import the text file?

Dan

 

[Guest]

Hi Dan

The zero's are in the text file -- the database removes them after importing
the data file. If that helps????

 

[dan dungan]

Hi Sue,

That's why I think you would be better served to ask this question on
a perl/cgi newsgroup. The field's data type doesn't seem to allow
0's. In my limited experience, 0's are not good in database fields.

How does it spoil your final output.

Dan