Recent content by suoirotciv

Thanks So its safe no side effects particularly to the database. ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

Is it safe to have a script that will run every week to truncate my temporary tables? ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

This is great . . thanks a lot . . . Here is what i do CREATE PROCEDURE dbo.IsFileExists @ExcelFileName VARCHAR(500), @IsFileExist INT OUTPUT AS DECLARE @FileExist INT Exec master.dbo.xp_fileexist @ExcelFileName, @FileExist Output SET @IsFileExist = @FileExist GO Public Function...

Thank you for the reply . . . but its not working. Or maybe I dont explain it well. genomon is right with the code Public Function DirExists(OrigFile As String) Dim fs Set fs = CreateObject("Scripting.FileSystemObject") DirExists = fs.FolderExists(OrigFile) End Function but my problem is...

Good day! I have this post under SQL thread183-1560051 that is already working. But since the we need to create a folder at MYserver as a dump location for our excel files for the OPENROWSET to work like D:\ExcelFiles\, I need my program to check first if the folder and files really exists...

hehehe it was just a typo error . . i just copy paste my original code and altered it for easy reading. ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

[2thumbsup] Cool!!! that was great. Thanks a lot. ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

Thanks! I was just thinking of a possible shorter method. ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

I'm already doing this code below Public Sub testloop() Dim x For x = 1 To 10 Select Case loopr Case 1, 3, 7 To 10 Debug.Print loopr End Select Next End Sub But is there a way for the loop to look like this? Ofcouse the sample below is not...

I got it, its not possible to pass variable to OPENROWSET so I just use EXEC But my problem now is that my excel file contains phone number and when the data was transfered to my table the phone number becomes like this "3.9522e+006" where my field is already varchar...

I need to loop to lots of excel file so i need to pass the file name. But using SET @FileName = 'C:\MyExcelFile.xls' and pass it on the code below is not working. FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\MyExcelFile.xls;HDR=YES', 'SELECT * FROM [Sheet1$]') My Code SET...

Is it possible to get the actual website of this url below, which is "http://www.starr-al.com/"...

Well thank you for keep tracking my post. If keylogger is the case, what can I do to fix this? ======================================== I kept my Job because of TEK-TIPS Thanks a lot to all who keeps on helping others.

Thank you for your reply. I tried what vb5prgrmr suggests but the location of the error is not always the same. but it is on the same user control (chameleonButton.ctl) that I already been using for I think 3 years. And only this new program I created encountered this error. Actually its...

I have a project that when I run, the application run as is. But when the time to close the application it crash. But when I open the project and compile it first before running, it never crash. What is the reason behind this? ======================================== I kept my Job because of...