Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Question Unanswered: Import from Excel question

    Hello. This may be a silly question. I think I already know the answer because I tried it and didn't work, but just in case I'm missing something, can an Excel file be imported into SQL Server if the column names are on the left? in other words, all the column names instead of being on the top of the sheet, they run down on cell A.

    Thank you!!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Short answer: yes.

    Long answer: not easily.

    Best answer: use Excel's "Paste special" functionality to transform the data first and save yourself days of headache.

    blindman

Posting Permissions

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