I've seen lots of questions relating to this subject so please excuse me for repeating question but....
I am using :
SELECT * INTO Product FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\Websites\d2v\D2V-database.xls', 'SELECT * FROM [Sheet1$]')
to import frm an Excel spreadsheet but its causing me problems.
Its bringing in about 200 extra rows than are actually populated in Excel and some of the columns dont import correctly. I also need to drop the table first for the import to happen which I'd rather not do due to table relationships, etc.
What is the correct script I should be using please?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.