Import of Excel puts NULL in every column

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Import of Excel puts NULL in every column

Author

Topic

steve.simpson
Starting Member

1 Post

Posted - 2010-07-16 : 03:55:28

I've been uploading loads of Excel 2003 and 2007 into SQL Server 2008. One particular spreadsheet with multiple sheets is causing a problem. I map all the fields as normal and then run the import. The table is populated with the correct number of rows but each field is NULL. I have an import date on the table that is populated correctly.

Can anybody offer any advice? Feel free to email me steve.simpson@aircelle.com and I can send you the spreadsheet and the table definition.....

Thanks

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-16 : 12:56:26

did you try to check the formatting in excel and whether the columns in table match this.
how did you construct the SSIS package?

ba7ranya
Starting Member

1 Post

Posted - 2010-07-31 : 06:17:55

Hi,

I created SSIS package to import data from excel sheet to OLE Sql

but after executing the package; these errors accours :

[Excel Source [158]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: component "Excel Source" (158) failed validation and returned error code 0xC020801C.

[Connection manager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

please advice

jim_jim
Constraint Violating Yak Guru

306 Posts

Posted - 2010-08-09 : 14:27:32

Whenever I have problems importing data from excel to SQL server
I try importing data first to Access and them importingback to SQL

Not sure why and it works always.This is just a turn around an not a solution

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources