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

    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
    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.


Posting Permissions

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