Adam Blumenfeld (1/31/2011)
Craig,I'm just using Microsoft SQL Server Management Studio to import from an .xlsx file direction. If I have the import wizard create the table, it only creates the first 255 columns, and imports them. If I first create a table in SQL Server, with the 700 columns that I need, and then try to import, it again only imports the first 255 columns, and leaves the others as NULL.
I'll have to muck with it to confirm, but my quick research when I saw this pop up indicated otherwise. However, I can't speak to what the wizard will do. Have you tried creating your own package in BIDS/VS2k8 and creating a source that hooks to Excel 12.0, and then the import?
I'm currently dealing with the drivers for that now at this location for the newer versions (I use 2k5 and office 2k7 isn't immediately available, without this installed: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en), so once I get that cleaned up in a few days I can perform some local testing.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA