**Excel data and SQL** It is important to note for users of the SQL*XL software which values are actually sent to the database when they use SQL from Excel to communicate to their databases.

Why not give SQL*XL a try today.

SQL*XL: SQL Excel software

Download SQL*XL now!

SQL*XL uses the value and not the formatted values in the sheet. If the value in a cell is e.g. displayed as 2.00 then the actual value is 2 and the formatting is set such that it displays with two decimals. SQL*XL will see this value as 2 and not as 2.00.

With dates this is a little more complex or perhaps it is just easier. A date in Excel has a numeric value. The number of seconds since 1/1/1900 I believe. What you see displayed in Excel is a formatted version as 13/Dec/2008 or Dec, 13th 2008 or whatever you have specified as default or specific formatting. SQL*Xl will take the numeric value always.