Most of the important part of the script was included above but here is the current version of the canned script I am retaining for future use.

--Excel 2007 – Make...

Probably. I work for a varity of clients and personally work with SQL 2008 express so I don't have as much experience with SSIS as I would like. In that...

I converted the spreadsheet to Excel 2003 and tried the following script:

SELECT *

INTO #t

FROM

OPENROWSET('Microsoft.Jet.OLEDB.4.0'

,'Excel 8.0;Database=D:\CO_07_New_Chart_of_Accounts.xls'

,'SELECT * FROM [Posting$]'

)

This worked fine. I then did some further searching and found the following...

Hi GSquared. Thanks for the response. I logged in as a domain administrator and the SQL service is started by a domain administrator. I checked the rights on the excel...