Search:

no SQL Manager only code vb6 or vba for excel

I need to export a sql server table in csv, but not all filed biut for example:
filed1,filed5,field9...
How to?

Do you need to copy the table or just the data? ie does the table already exist in the second database?

- table and the data

To copy the data you can use two ADO connections.

Moving through...

How to via vb6 classic or vba for excel...
Copy table1 from database1 in sqlserver1 to database2 in sqlserver2?
note:
I have user and password trusted in windows login.

Hi use this cod eto have a number of cells in column.

dim cella as long
dim ws4 as worksheet
Set WS4 = ThisWorkbook.Worksheets("TEST")
CELLA = WS4.Range("C" & Rows.Count).End(xlUp).Row
...

NATURALLY WORK!
Tks.

work perfect!

sorry but how to calculate datediff in days between 20100405 and 20100409 ...in this case is 5
Tks.

I have a var filled with 20100405 is possible to check if the datae is really a monday?
Tks.

error: member or method not fiund
in line rs.NoMatch

Correct this part of code to find value in field?

.....

TEST_INDICE = ""
TEST_INDICE = Trim(Sess0.SCREEN.GetString(P, 22, 3)) & "-" & Trim(Sess0.SCREEN.GetString(6, 46, 9)) & "-" &...

i want to use begintrans,committrans and RollbackTrans on access table and ADO.
But is required rs.update in the code or CommitTrans have the same result of rs.update???

Private Sub saveclick()...

I get a part of string from a loop in text file with:
IMPORTO_OPERAZIONE = Format(Trim(Mid(inString, 88, 24) * 1), "#,##0.000")
i have dimensioned IMPORTO_OPERAZIONE as double but the code return:...

Have a userform with a cmobobox named Months and a combobox named Years
Combobox years is filled with a value: 2010,2011,...2020
Combobox months is filled with all months
I need when i select a...

similar:

'Outside your Loop

set rst=New ADODB.Recordset
strSQL="SELECT * FROM tblTest "
rst.Open strSQL,conn, adOpenStatic, adLockReadOnly

'Then inside your loop after var is set

ok... tks for code.
But the var is dinamic.... i fill var from a loop in range in Excel colum.
If i use your code is required to open and closed recordset each time, or not?

I use in my vb application the tipical ado jet 4.0 conn to Access table.
Now i have a var filled with "01".
In the table of my mdb have fields Test and Test1 with a value similar:

Test Test1
01...

... but instead to open dialogbox, i know the name of file, how to set Vfile?

I looping in text file "line by line".
During the loop i get a part of string line and store it in My_Var (my_var is dimensioned as string).
Now, i want to save all values of my_var in an array or...

Hi have in c:\my_dir\ many file with .mdb extention file.
I want to loop in dir c:\my_dir\ and delete the last one file oldest base the actual files are presents in dir.
How to?

example:...

I check the file existis in local with a simple script for example if the file is in c:\my_dir\my:file.txt
But if the file is in \\server_dir\my_file.txt the same code not work, why?
have a tips.?

work! tks.

i have this var
DATA_TIPOLOGIA=06/01/2010
how to subtract one month and have DATA_TIPOLOGIA=06/12/2009
note:
DATA_TIPOLOGIA is dimensioned string

Tks to thr all...!!!
Resolaved with one or more solution in this post.

... but if i am not wrong, the line code delete all blank space, or not?
In effect i want to reduce the number of blank space in one only.
example:
if the string contain 4 balnk space reduce the...

I have a variable My_Var dimensioned as strng.
The var can assume value, similar "sal vatore" or "s vatore"....
I want replace the number of blank space in internal of string with only one...