Can you please advise me which is the best method of importing data into SQL from Excel (2007), Bulk Insert or OpenRowSet. Currently I've tried both and neither is working and before I continued to battle I thought I'd see which is the best option.
asked May 10, 2011 at 06:51 AM in Default
You can try to Install the 2007 Office System Driver: Data Connectivity Components. Then you should be able to
Eventualy HDR=No if there are no columns headers.
answered May 10, 2011 at 12:09 PM
If it were me I would use SSIS and use an EXCEL Source and handle the import there. You could also use a data conversion task to handle any data manipulation that might be needed.
answered May 10, 2011 at 06:55 AM