Thank you Guys !

I will work on problem today 🙂
And i will you let you know.

Thank you
Jacek

Thank you DimPerson,

i tried with double slashes and with sometihng like that:


dbconn.Execute("C:\\Users\ljar01\Documents\SQL Server Management Studio\BulkInsert.sql")

Best Wishes,
Jacek

Hi All,

I found the code whis is working and opening database!

dim dbconn, ConnectionString
ConnectionString ="Provider=SQLOLEDB;Data Source=NR90F56ZX\SERVERTEST;" & _
      "Initial Catalog=QlikView;" & _
      "Integrated Security=SSPI;"
Set dbconn = CreateObject("ADODB.Connection")

dbconn.Open ConnectionString


The last problem...

Hi Thom A,

thank you.

The code below throws error:

dim dbconn, ConnectionString
ConnectionString = "Driver={SQL Server};Server=NR90F56ZX\SERVERTEST;database=QlikView;IntegratedSecurity=yes;"
Set dbconn = CreateObject("ADODB.Connection")
dbconn.Open ConnectionString
dbconn.Execute("C:\Users\ljar01\Documents\SQL Server Management Studio\BulkInsert.sql")

Error is connected with "/" sign:

Thank you very much ! 

It is working!
Best Wishes,
Jacek

Hmm it is very strange - now i file was uploaded with success! 

I will test the file tomorrow also and i will let you know if it is...

Hi Guys,

in attachment there is my flat file from where I am trying to upload data into MS SQL Server.

Please help with creating Query for it..

Hi Guys, 

thank you for helping me,
my code is:

USE QlikView
GO

CREATE TABLE tbl_Slownik
(
    ID INT IDENTITY(1,1),
    UniqueID NVARCHAR(50),
    Data_Zmiany Date,
    PESEL...

Hi,

thank you Anthony.
I think that your code is working but without using FORMATFILE:

so here is a problem with ID field which is set as...

Hi Guys,

thank you for helping !
MY CSV is not looking like standard CSV. 
Is looking like Excel with columns. 

Ok, how can i specify syntax in...

Hi Dennis,

thank you for your precious answer ! 

It is working like a charm.
Problem was also connected with nulls in my database within float field. 

Thank you Guys,

i used :

Select
*,
CAST(Company_NIP as float) as Company_NIP2
FROM QlikView.dbo.tbl_Slownik

and there is NO any problems within this.

Thank you Steve! 

Hi Eirikur, 

thank you very much!
So question here:
are SQL Administrators do often what you have suggested me?

If yes, i will do that.

Thank you Steve,

From flat file it is good when i am downloading all data as a string. 

Next data converstion is used and I am converting string...