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!!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.
blindmansql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment