Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2014
    Posts
    1

    Unanswered: Data changing format from excel to SQL

    When I am bringing my data from Excel into SQL via VBA code, it leaves Excel as "CAPITAL" but ends up in the table as "capital". I would default to use Ucase(variable) but my team leader would rather something the team didn't have to remember to go in and put Ucase when it was needed (as it is not needed all the time).

    Am I missing something between the two that would cause the data to be changed going from Excel to SQL?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Care to share the VBA code?
    Do the columns in question in Excel contain functions or values?
    George
    Home | Blog

  3. #3
    Join Date
    Aug 2008
    Posts
    147
    Hi, check the column collation and any code in VBA
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Tags for this Thread

Posting Permissions

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