SQLSearcher
asked on
SSIS Excel Import losing the number fields
Hello Experts Exchange
I have a Excel 2003 spreadsheet that has a table of data and I'm trying to import in to SQL Server 2012 database, but I am losing the numbers from the spreadsheet.
The cells with the numbers are made up of just a number in the cell and some are formulas.
Has anyone come across this problem before?
Thank you for reading
Regards
SQLSearcher
I have a Excel 2003 spreadsheet that has a table of data and I'm trying to import in to SQL Server 2012 database, but I am losing the numbers from the spreadsheet.
The cells with the numbers are made up of just a number in the cell and some are formulas.
Has anyone come across this problem before?
Thank you for reading
Regards
SQLSearcher
Can you expand on 'losing the number fields', with perhaps a screen shot or data mockup?
Smoke? Magic? Mirrors? Losing My Religion by REM? Having a hard time picturing this.
>and some are formulas.
Hmm. Not sure if the formula-calculated value will import..
Smoke? Magic? Mirrors? Losing My Religion by REM? Having a hard time picturing this.
>and some are formulas.
Hmm. Not sure if the formula-calculated value will import..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello
I was able to import data after moving the data to a new worksheet.
Regards
SQLSearcher
I was able to import data after moving the data to a new worksheet.
Regards
SQLSearcher
In the Excel the data you can see is integer but default data type while extracting data from Excel will be varchar and while Loading that data to SQL table which has int data type the data might not getting matched and hence it is losing.
Just use derived column / Conversion colum and convert that field to integer.
That will do