Results 1 to 2 of 2

Thread: SQL Question

  1. #1
    Junior Member
    Join Date
    Jan 2005
    Posts
    12

    Question SQL Question

    I have a SQL that when runs pulls information where one of the fields start with a zero or multiple zeros. When i export to excel it is auto deleting the zeros. I already went in and set column A to be put as text when i open ANY excel document. Problem being, is that when i export to excel it doesn't go to that excel book. It goes to a SQL default excel spreadsheet. Is there somewhere that i can redirect it or program it to go to have column A be text?
    I\'d try to be pestimistic, but that probably wouldn\'t work.

  2. #2
    Senior Member
    Join Date
    Oct 2003
    Location
    MA
    Posts
    1,052
    That probably has to do with the formatting of the cell try some different settings... Excel may see 0 as well what it is, nothing and omit it if that makes sense.

Similar Threads

  1. sql question??
    By newbiesvn in forum Newbie Security Questions
    Replies: 4
    Last Post: February 4th, 2004, 01:16 PM
  2. SANS WebCast: SQL Slammer Worm, Complete with expert commentary
    By xmaddness in forum Microsoft Security Discussions
    Replies: 0
    Last Post: January 27th, 2003, 11:18 PM
  3. SQL Sapphire Worm Analysis
    By s0nIc in forum AntiVirus Discussions
    Replies: 2
    Last Post: January 27th, 2003, 12:23 PM
  4. Test Your General Linux Knowledge
    By smirc in forum AntiOnline's General Chit Chat
    Replies: 6
    Last Post: May 13th, 2002, 04:35 PM
  5. Test Your Knowledge of Redhat?
    By smirc in forum AntiOnline's General Chit Chat
    Replies: 3
    Last Post: May 13th, 2002, 03:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •