I am importing an excel file to MSSQL with the following script:
SELECT * INTO Z_StockImport
FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=\\path\StockList.xls;Extended Properties=Excel 12.0')...[StockList$];
GO
The problem is that one of the columns has very long numbers, but they have to stay this way, so instead of the original value: 2185693631 it changes to: 2.18569e+009
It's some automatic mechanism, so I cannot do changes on the excel before importing it.. how can I specify during the import to keep the value as is OR how to update in the MSSQL afterwards that it will change back to the original number?
Thanks
Bookmarks