OK i finally find a solution and wanted to share it with you in case it is useful to someone else.

The problem of the bulk import is the difference of...

hello all,

Thanks for your feedback.

The OPENROWSET will not work for me due to limited permissions in accessing my SQL server.

I am pretty sure the issue is linked to the...

Thanks Steve,

Just tried your code in my VB.Net application:

cnSQL.ConnectionString = "Data Source=TETAUTAI;Initial Catalog=TUNA_DBS;UID=user;PWD=pwd;"

cnSQL.Open()

...

Thanks all for your replies

THis is the SQL code of my table in SQL Server:

CREATE TABLE [ARCHIVAL].[ARC_DATA](

[arc_data_id] [int] IDENTITY(1,1) NOT NULL,

[arc_tag_id] [int] NOT NULL,

[date_UTC] [datetime] NULL,

[date_local] [datetime] NULL,

[depth] [decimal](6, 2)...

Thanks David,

I just tried to change the data type in my schema.ini for the temperature with float:

Col4=TEMP_INT float and i obtain the same uncertainty about the rounding.

It seems that...

Thanks for your answer.

What do you mean about the cell format?

In my SQL Server, the field has been defined as decimal(5,2), i tried with Numeric(5,2), and i have still...

Thanks Adiga

We don' t have reporting services with a report server installed in our SQL Server configuration.

Is there any other ways using a stored procedure for example to be executed...