Dim dbs As Database Set dbs = OpenDatabase("Northwind.mdb") dbs.Execute " INSERT INTO Employees " _ & "(FirstName,LastName, Title) VALUES " _ & "('Danny', 'Glover', 'Actor');" dbs.Close “Never was anything great achieved without danger” ~ Niccolo Machiavelli. In VBS. Wenn ich nun damit z.b. Dim cn 'connection object Dim rs 'record set object Dim mc 'command objet Dim sql Dim column1 Dim column2 Dim column3 Dim column4 SQL insert, update and delete commands, any QlikView field data can be updated directly in RAM. On a server the updated data is pushed out to the clients. Running on W2000 Server. I need help in creating the connection string and populating the database table instead of outputting the results to a text file. I have issue with SQL server. Hallo, ich lese Daten von einer Datenbank ein und schreibe sie in eine andere. How to populate a SQL Server table via a VBS script? Microsoft Access / VBA Forums on Bytes. What I want to do is to store the data extract into a SQL Server table. It writes the sql file ok.

I need the 'shortcode' entering into the table - don't ask! When I try to write tag value from WINCC a have a trouble because I can't write a value with characters like "ABC" or "A1B2C3". Hello everyone! Is there a 1-step SQL way of doing this? sotando (Programmer) (OP) 8 Jan 11 00:06. When i change my SQL-string to "Select * from " eigther within VBS or VBA it works fine, but i need to use the sproc. I use VBS Update if Record exist, otherwise Insert.

Insert. Hello All, I found the below script on the net and I modified it slightly. Now copy this scipt there. The sproc also works fine within query analyser of SQL Server 2000 (SP3). Click on "Insert" button and browse to "Events > Static Text > Mouse > Mouse Click > VBS-Action". Beim Einlesen der Daten habe ich auch Kommentare, die ein ' enthalten. See … what is it i'm not seeing - could you pleas help. I need to insert the record. However value consisted of numbers have no problem to write in my database.Type of tag which i use is text 16bit characters. Now copy this scipt there. Related: Delete - Delete records. Add records to a table (append query). ein SQL-Insert bilde, kracht es, weil ich versuche ja dann einen Wert einzufügen, der so aussieht: I need the 'shortcode' entering into the table - don't ask! This functionality is freely available in stand-alone QlikView but requires an additional license on QlikView Server.