I'm using OpenRowSet to successfully export data from a SQL Server table to Excel as well... however all data is coming down as text.

I've tried formatting the target spreadsheet as numeric to no avail. Is there something specific I need to do to get numbers and dates to export in their native format?

Thank you.

Doug