Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OpenRowSet() and currency precision
Message
From
24/07/2021 15:25:30
 
 
To
24/07/2021 13:38:04
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01681915
Message ID:
01681929
Views:
33
>>I don't if know this will help
>>I created a spreadsheet with a column that looked like this 5.12345678
>>I used the SQL Server import wizard and the wizard converted the data OK. It made the column a float type.
>
>Did you format the Excel cell as Currency?
As a number.
See attached
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform