Import a csv-file into MS access with the aid of vbScript

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Null values in Win32_MappedLogicalDisk Ok, I've figured out how get the network drives off a remote machine, but I'm having a new problem... Problem is that when I use the below code, the ProviderName property is Null (supposed to be a string of where drive is mapped to). BTW, I'm using XP on an AD domain. I am an admin of all workstations in domain. Why? Where is this set at? Is there no hope? Code for getting Network drives for remote computers: strComputer = "remotecomputername" Set wmiWin32 = GetObject("winmgmts:\\" & strComputer & "\root\cimv2") Set colItems = wmiWin32.ExecQuery("Select * from Win32_LogonSessionMappedDisk") For Each objItem in colItems set obj = wmiWin32.Get(objItem.Dependent,0) Wscript.echo obj.DeviceID Wscript.echo obj.ProviderName Next Win32_LogonSessionMappedDisk's Dependent returns object for Win32_MappedLogicalDisk for logged on user. Supposedly, the ProviderName property is where the drive is mapped to. NOTE: ProviderName is still null when I call directly from Win32_MappedLogicalDisk on my local workstation. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141959
  - 2
    - Active Directory User Login Script Path Hi, I'm tryng to incorporate an AD script I run nightly to list out what user has what login script. When I refer to the obj.Fields("scriptPath") within AD I get: Item cannot be found in the collection corresponding to the requested name or ordinal. Which I am assuming is telling me the field doesn't exist with in the user object. Is this a correct assumption? I use the source class user and pull other attribute names without a problem. Any ideas on how to extract the user login script path from AD? Thanks Paul Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141958
  - 3
    - Values of TaskItem Fields are lost when saves to folder Hello all I made a task form and place some user defined fields on one page(Edit Compose page) and then some fields from are copied to the Edit Read page of same form. I saved this taskitem to some folder, it is saved well. But when i open the task from the folder by double clicking on task in table view i found that the the controls shows the intial values of fields. Summary: I want to know how to save the values of user defined fields when the taskitem is saved to folder. Thanks I have used the following code: Const olFolderTasks=13 Sub CommandButton1_Click StrMessageClass=Item.MessageClass dim StrAssignTo StrAssignTo = "helpdesk3@hub.com" Set MyApp = CreateObject("Outlook.Application") Set MyNameSpace = Application.GetNamespace("MAPI") Set MyTaskFolder = MyNameSpace.GetDefaultFolder(olFolderTasks) Set MyItem = MyTaskFolder.Items.Add("IPM.Task.tasktry5") Item.MessageClass = StrMessageClass MyItem.Recipients.Add StrAssignTo MyItem.Subject = "You will definitely get" MyItem.DueDate = Now() + 2 MyItem.Body = "Keep it up" Item.MessageClass = StrMessageClass MyItem.Assign MyItem.Save MyItem.Send MsgBox "the task is saved to " & MyTaskFolder End Sub -- Posted via http://dbforums.com Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141957
  - 4
    - Creating 90000 users and placing randomly them into thirty OU's I've found a script or two through the news groups (here and on the WSH group) that allows me to create a couple of thousand users. Now what I'm trying to figure out is how to get those users to "shuffle" themselves into one of thirty OU's under the users. DOM |_OU1 | | | |_users | |_bob | |_doug |_OU2 | |_users |_bob2 |_doug2 and so on...up to thirty OU's with the 90000 users being placed (or like cards, "dealt") into one of the thirty groups randomly. What I'm trying to do is break the AD database, incidentally by seeing how many "bob's" I can cram into the database. Here's the script that I've been tinkering with from one of the folks on the newsgroups. =================================== For i = 1 To 90000 Set objDomain = GetObject("LDAP://dc=bob,dc=com") Set objOU = objDomain.Create("organizationalUnit", "ou=OU0" & i) objOU.SetInfo Set objUser = objOU.Create("User", "cn=bobby0" & i) objUser.Put "sAMAccountName", "bobby0" & i objUser.SetInfo objUser.AccountDisabled = FALSE objUser.SetPassword "password" objUser.Put "pwdLastSet", -1 objUser.AccountExpirationDate = "01/01/2050" objUser.Put "givenName", "Bobby" objUser.Put "initials", "B" objUser.Put "sn", "User" objUser.Put "displayName", "Bob, Bobby" objUser.Put "physicalDeliveryOfficeName", "Room 707" objUser.Put "telephoneNumber", "(320) 762-xxxx" objUser.Put "mail", "bobby@bobby.com" objUser.Put "wWWHomePage", "http://www.bob.com" objUser.SetInfo Set objUser = objOU.Create("User", "cn=Bob0" & i) objUser.Put "sAMAccountName", "Bob0" & i objUser.SetInfo objUser.AccountDisabled = FALSE objUser.SetPassword "password" objUser.Put "pwdLastSet", -1 objUser.AccountExpirationDate = "01/01/2050" objUser.Put "givenName", "Bob" objUser.Put "initials", "B" objUser.Put "sn", "User" objUser.Put "displayName", "Bob, Bob" objUser.Put "physicalDeliveryOfficeName", "Room 666" objUser.Put "telephoneNumber", "(613) 762-xxxx" objUser.Put "mail", "bob@bob.com" objUser.Put "wWWHomePage", "http://www.bob.com" objUser.SetInfo Next WScript.Echo "90000 OU's and Users created." Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141956
  - 5
    - Opening a new Window Hi, I have the following code which seems to function OK onclick="window.open('sales.asp?Reference=<%=rstContacts (0).Value%>')" However, I would like to set up the Scrollbars to false and specify a height and width for the new window. I am aware you can pass these parameters into the window.open function but I cannot figure out the syntax for the above line. Can anybody shed some light on this Many thanks Mark Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141951
  - 6
    - ProxyAddresses Does anyone have a script to set the ProxyAddresses property for a contact. I tried this script , but have some problems with the DIM commands...Is there another way? Marc sub SetProxyAddress(recipname As String, _ DomainName As String, Proxies) 'DomainName is something like "DC=MYDOMAIN3,DC=example,DC=com" 'recipname is something like "jamessmith" Dim objPerson As New CDO.Person Dim objMailRecip As CDOEXM.IMailRecipient Dim i objPerson.DataSource.Open "LDAP://CN=" + recipname + _ ",CN=tele_contacts," + DomainName * * * Set objMailRecip = objPerson objMailRecip.ProxyAddresses = Proxies objPerson.DataSource.Save MsgBox "Proxy addresses for " + recipname + " set successfully" End sub Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141947
  - 7
    - ProxyAdresses Does anyone have a script to set the ProxyAddresses property for a contact. I tried this script , but have some problems with the DIM commands...Is there another way? Marc sub SetProxyAddress(recipname As String, _ DomainName As String, Proxies) 'DomainName is something like "DC=MYDOMAIN3,DC=example,DC=com" 'recipname is something like "jamessmith" Dim objPerson As New CDO.Person Dim objMailRecip As CDOEXM.IMailRecipient Dim i objPerson.DataSource.Open "LDAP://CN=" + recipname + _ ",CN=tele_contacts," + DomainName * * * Set objMailRecip = objPerson objMailRecip.ProxyAddresses = Proxies objPerson.DataSource.Save MsgBox "Proxy addresses for " + recipname + " set successfully" End sub Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141946
  - 8
    - 'if exist' vbscript equivalent In batch files I often used something like: If Exist C:\test.flg then ... or If Not Exist C:\test.flg then ... What's the vbscript equivalent? -- Posted 'as is'. If there are any spelling and/or grammar mistakes, they were a direct result of my fingers and brain not being synchronized or my lack of caffeine. Mike Brearley Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141929
  - 9
    - CLOB field and GetChunk Hi there, Hope someone will be able to help with that weird problem I'm facing. I'm querying a CLOB field from an Oracle 8 DB, in an ASP page. I manage to retrieve the value of my CLOB field by using the GetChunk (the value is an HTML code). My problem is that each time, the first 6 or 7 characters of my code are missing (but when looking directly in the DB, I see that the HTML codes in my table are fine). For example, I've one of my code starting with : <script language="JavaScript"> pp409217=window. open ('','','scrollbars=no,resize=no,height=200,wid th=350'); Once retrieved with GetChunk, I get : language="JavaScript"> pp409217=window. open ('','','scrollbars=no,resize=no,height=200,wid th=350'); (<script is missing). The code I use is : sql_query = "" sql_query = sql_query + " select text as code " sql_query = sql_query + " from rendering" sql_query = sql_query + " where id = " & id 'cnnprod is my connection object set requete = cnnprod.execute(sql_query) tempcod = requete.fields("code").getChunk(15000) response.write tempcod Does anyone have an idea of what would be causing the problem ? Thanks Salem Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141923
  - 10
    - Comment alerter les PC contaminés ? Bonjour, J'ai crée une règle dans mon firewall (Kerio) qui piste toutes les attaques aux ports 135 (et autres). J'en ai environ une par minute... Je voudrais prévenir les possesseurs des PC contaminés. La seule info que j'ai c'est leur IP, comment pourrais-je les prévenir ? Exemple: 28/Aou/2003 19:26:36 Attaques MSBlaster... blocked; Ent TCP; montmartre-4-81-57-189-90.fbx.proxad.net [81.57.189.90:2854]->localhost:135; Owner: C:\WINDOWS\SYSTEM32\SVCHOST.EXE Discussion suivi sur le groupe: news://news.microsoft.com/microsoft.public.fr.securite . -- @:-) FAQ Windows XP ==> http://a.vouillon.online.fr/ Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141917
  - 11
    - Help with variable SQL queries Hi All, I'm writing a asp page to create queries to a database and want my users to be able to specify criteria. So far, I've come up with the following code: If Request.Form("CL1") AND NOT Request.Form("CL2") AND NOT Request.Form("CL3") then ClasCrit="1" If Request.Form("CL2") AND NOT Request.Form("CL1") AND NOT Request.Form("CL3") Then ClasCrit="2" If Request.Form("CL3") AND NOT Request.Form("CL1") AND NOT Request.Form("CL2") Then ClasCrit="3" If Request.Form("CL1") AND Request.Form("CL2") then ClasCrit="1 OR 2" If Request.Form("CL1") AND Request.Form("CL3") then ClasCrit="1 OR 3" If Request.Form("CL2") AND Request.Form("CL3") AND NOT Request.Form("CL1") then ClasCrit="2 OR 3" If Request.Form("CL1") AND Request.Form("CL2") AND Request.Form("CL3") then ClasCrit="1 OR 2 OR 3" It works, but is there a more elegant and succinct way of doing the same thing? My way seems very cubersome. Thanks for any input, Dave Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141898
  - 12
    - File I have the following code where I am trying to write a header in file. I am getting some crap in new file. Please help me. Const ForWriting = 2 Dim fso, theFile strDate = Year(Date) & Right("0"&Month(Date),2) & Right ("0"&Day(Date),2) Set fso = CreateObject("Scripting.FileSystemObject") rootDir="C:\" Set theFile1 = fso.createTextFile("C:\Header.txt", ForWriting, True) theFile1.writeline "HST" & strDate theFile1.Close FileSpec1 = "C:\Header.txt" sFileSpec2 = "C:\test.txt" With CreateObject("Scripting.FileSystemObject") set f1 = .OpenTextFile(sFileSpec1, 8) f1.Write .OpentextFile(sFileSpec2, 1).ReadAll f1.Close End With Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141897
  - 13
    - DirectX Version I am trying to write a script to determine the version of directx installed on Windows2000 and WindowsNT4 servers. It seems as easy as doing a REG_READ for the Software\Microsoft\DirectX\Version key, but what version numer is the latest, or should I say what version indicated 9.0b? Thanks in advance. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141896
  - 14
    - WSH shortcut's traget path Hi, I am having trouble figuring out how to set a target path for a desktop shortcut. This how I would like the target field to appear in the icon: "c:\pathto\msoffice\access.exe" "\\PathToSomeSvr\AndOpen\thisDB.mdb " /With /LotsOf /DifferentSwitches When I try to do this the icon is built with the whole string enclosed in " " and / are turned around to \ . I have tryed and tryed with not success. If anyone could show me how to build this path or point me in the right direction would be nice. Thx Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141890
  - 15
    - Logoff when inactive n minutes Hi, I want a script that logs off students after an idletime of n minutes.. I have the following script: Set oSet = GetObject("winmgmts://COMPUTER").InstancesOf("Win32_OperatingSystem") For Each os In oSet call os.Win32Shutdown(4, 0) Next This will log off a user on that computer. But I also need to get the idletime on a user present on that computer. Is that possible? I know there's a Idletime in AD on Windows XP, but my clients are running Windows 2000 Pro Sp4. I have tried installing the logoff screensaver, but its not working well. I wanna run this remotely e.g. each hour. -- Hallstein Department of Informatics Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141887
  - 16
    - script or Policy template to move Temporary Internet Files folder Gurus, I am looking for a script or Policy template that when a user executes it their Temporary Internet Files folder will be moved from the default location (%userprofile%\Local Settings\Temporary Internet Files) to a different folder. Any suggestions? -- Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141886
  - 17
    - Rename scheduled task name Hi, How can I rename the description and comments of a scheduled task in Windows 2003 using VBscript? Lars Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141885
  - 18
    - BIG problem with RegExp - HELPPPPP Hi All, I'm using the RegExp to parse some IMail Logs so that I can upload it to a database and manage it to create special reports. I did everything OK. The 20 logs worked fine, but in one o another, where normally a process take just 2 minutos to do the Execute, do not stop... took the regular CPU usage and do not stop for more than 16 hours, when I stopped it at Task Manager. The average of log files was about 8MB... but it worked fine with 20MB too... took, about 0 minutos to execute. Follow the sample code that I'm using. Set regEx = New RegExp REM ======================================================================= REM Processa Leitura de Mensagens pelo IMAP4 e POP3 REM 07:21 00:02 IMAP4 (00000A34) logon success for zevallos zevallos.com.br from 200.217.215.158 REM 07:21 00:03 IMAP4 (00000A34) logoff for zevallos R:100, D:100, P:0 REM REM 07:21 00:03 POP3D (00000E48) logon success for autodestaque diariodopara.com.br from 10.10.1.31 REM 07:21 00:03 POP3D (00000e48) logoff for autodestaque R:0, D:0, P:0 WScript.Echo "Processando Leitura de Mensagens pelo IMAP4 e POP3" WScript.Echo regEx.Pattern = "(.*:.*) (.*:.*) (POP3D|IMAP4) \((.*)\) logon success for (.*) (.*) from (.*)\n" regEx.IgnoreCase = True regEx.Global = True WScript.Echo "Search: " & Now() Set Matches = regEx.Execute(strLogFile) WScript.Echo " - " & Now() & " - Ítens encontrados: " & Matches.Count Abraços, Ruben Zevallos Jr. [ruben@zevallos.com] +55 91 8116-7668 ------------------------------------------- Instant Messengers Yahoo: Zevallos AIM: RubenZevallosJr ICQ: 2402977 MSN: RubenZevallos@hotmail.com ------------------------------------------- HiperTools® 3.0 Developer > http://www.hipertools.com.br/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 8/20/2003 Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141880
  - 19
    - Checkbox Hi All, I want to display the value of my input of type check box. How do I set the checked/ unchecked values inside the <input....> Thanks in advance Roberto Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141873
  - 20
    - Variable length left border How can I increase or decrease the height of the left border to match the height of the body of a web page? I'm using shared borders and want the left border to reach the bottom border where left and bottom are block colours to avoid the nasty gap. Brian Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141868
  - 21
    - VBS Log Off Script Hello, I have already writen my login script in vbs to map network drives. In windowsXP under an active directory with a group policy, what is the correct syntax for a VBS file to UNmap network drives? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141867
  - 22
    - Newb Help: How do I find out what does in CreateObject() Hi vbscript guru's. I am a php mainly but php won't cut it in this situation so I think I'm looking to vbs and/or javascript to hand off the variables to php. I'm a vbs Noob so bear with me if my terminology is wrong. Here is my situation. I have a series of IE Plugins to check for (Flash, Real Audio, if the user is using AoL, etc, etc,) I see through searching that the CreateObject() is used with some error catching to see if the Object is present. Error mean no plugin no error means its running Now what I am wondering is how do I know what goes in the ()? Is there a list that IE can spit out or something in my registry i can lookup, or am I going to each of the major plug in makers and asking them? Perhaps there is an online resource for this... Any help or direction would be appreciated. Cheers and thanks to all in advance, Gary Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141863
  - 23
    - Select Case True and type mismatch Hi, I found this script out there on the net and it seems perfect for what I want to do. That is Ping a series of IP addresses and retern the info to an Excel Spreadsheet. Unfortunatly, it uses the Select Case True method, which I am not familliar with. Here is the error I get when I try to run the script: E:\Utilities\AdminTools\IP Ping.vbs(78, 2) Microsoft VBScript runtime error: Type mismatch: '[string: " Pinging ndcspi02."]' And here is the code: 'IP Ping.vbs 'Ping multiple computers taken from a list in a text file out put to an Excel Spreadsheet ' Requirments: List of IP Addresses in a file called (See strFileName for the required text file) ' One IP Address per line ' Excel is needed ' Script was written in Windows XP using Wscript 5.6 ' No blank line at the end of the script '********************************************************** ******************************** Option Explicit Const ForReading = 1 Const ForWriting = 2 Const ForAppending = 8 Dim strFileName : strFileName = "IPAddress.txt" Dim Fso : Set Fso = CreateObject ("Scripting.FileSystemObject") Dim oXLS : Set oXLS = WScript.CreateObject ("Excel.Application") Dim WshShell : Set WshShell = createobject("wscript.shell") Dim i Dim intIndex Dim oFile Dim png Dim strComputerIP() Dim strIpAddress Dim strPing Dim strReply Dim strRet Dim strCname If Not Fso.FileExists(strFileName) then strRet = Msgbox("The file, " & strFileName & " is not available" & vbCr _ & "The file must be located in the same folder as the script." & vbCR _ & "Please check for the file <<" & strFileName & ">in the folder" & vbCR _ & "<<" & Fso.GetParentFolderName (Wscript.ScriptFullName) & ">>") Wscript.Quit End if Set oFile = Fso.OpenTextFile(strFileName, 1) 'Configure Excel while leaving the spreadsheet hidden oXLS.WorkBooks.Add oXLS.Columns(1).ColumnWidth = 20 oXLS.Columns(2).ColumnWidth = 30 oXLS.Columns(3).ColumnWidth = 40 'Set column headers oXLS.Cells(1, 1).Value = "IP Address" oXLS.Cells(1, 2).Value = "Computer Name" oXLS.Cells(1, 3).Value = "Return" 'Format text (bold) oXLS.Range("A1:C1").Select oXLS.Selection.Font.Bold = True oXLS.Selection.Interior.ColorIndex = 1 oXLS.Selection.Interior.Pattern = 1 'xlSolid oXLS.Selection.Font.ColorIndex = 2 'Left Align text oXLS.Columns("B:B").Select oXLS.Selection.HorizontalAlignment = &hFFFFEFDD ' xlLeft intIndex = 2 i = 0 Do Until oFile.AtEndOfStream Redim Preserve strComputerIP(i) strComputerIP(i) = oFile.ReadLine 'Ping Ip Addresses set png = WshShell.exec("ping -a -n 1 " & strComputerIP (i)) do until png.status = 1 : wscript.sleep 10 : loop strPing = png.stdout.readall 'NOTE: The string being looked for in the Instr is case sensitive. 'Do not change the case of any character which appears on the 'same line as a Case InStr. As this will result in a failure. Select Case True Case InStr(strPing, "Request timed out", 1) strReply = "Request timed out" strCname = lcase(getcName(strPing)) Case InStr(strPing, "could not find host", 1) strReply = "Host not reachable" trCname = lcase(getcName(strPing)) Case InStr(strPing, "Reply from", 1) strReply = "Ping Succesful" strCname = lcase(getcName(strPing)) End Select If strCName = "" then strCname = "N/A" End If Call Show(strComputerIP(i), strCName, strReply) i = i + 1 Loop 'Make the spreadsheet visable oXLS.Visible = TRUE Function GetcName(ByVal reply) Dim C, tempcName C = Instr(reply,"[") If C = 0 Then Exit Function TempcName = mid(reply,12,C-12) 'Used to remove the FQDN from the computer name. GetcName = replace (tempcName, ".ci.charlotte.nc.us", "",1) End Function Sub Show(strIP, strName, strValue) oXLS.Cells(intIndex, 1).Value = strIP oXLS.Cells(intIndex, 2).Value = strName oXLS.Cells(intIndex, 3).Value = strValue intIndex = intIndex + 1 oXLS.Cells(intIndex, 1).Select End Sub Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141856
  - 24
    - AdsPath If I know the computer name, I do I find the AdsPath for that computer name? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141855
  - 25
    - HTA (mshta.exe) won't terminate if java applet is running under XP Hello everybody, I searched the groups for days ... Following Problem: I have an HTA with a java applet in it. Works fine. And when I close it, the window is away. But the mshta.exe process is still running and won't terminate. I think it's because mshta.exe is waiting for the applet to close. On an HTML page ist works. And the other thing: this problem occurs only under windows xp. w2k,ME,98 will terminate mshta.exe without waiting for the applet. The applet is running with the actual Sun VM Java 1.4.1_02 and NOT with MS VM. How can I unload or stop the applet, so mshta.exe will be terminated on XP? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141844
- Next
  - 1
    - script to see if service is running Does someone have a sample script I could use to run on my network to see if a specific service is running? It is actually for remote computers so I would need to be able to define an ip address range to scan the entire range. I would like to be able to log it to a file. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141841
  - 2
    - methods, properties and events of an object I would like to write a script (vbs) to enumerate methods, properties and events of an object. Any idea ? Thanks. Laurent. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141836
  - 3
    - Command Line Arguments In a script (.vbs file), how do I capture command-line arguments? Say I have a script named "Script.vbs" at C:\, which contains the following code: MsgBox Command then run it from a DOS window (at the C:\ prompt) by typing: Script.vbs "Test" I want a message-box to pop up with "Test" in it. However, all I get is a blank message-box with an 'OK' button. What do I need to put in the place of 'Command'??? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141833
  - 4
    - Displaying page,,, Hi All, I have a web page, this page has two display form methods. One is to display a confirm delete and the other to display a message when the record is deleted. The problem is that when I choose Yes on the page to confirm delete only part of the second page is display and not all the page. What could be the problem? Here is my code.... <% '************************************************************ ' Purpose: Organization Insert/Update page '************************************************************ OPTION EXPLICIT '******** 'Includes '******** %>  <% '********* 'Constants '********* const adInteger = 3 const adCmdStoredProc = &H0004 '***************** 'Private Variables '***************** dim conn dim command dim rs dim strFlow '***************************************** 'Session Variables Referenced In This File ' session("OrganizationID") '***************************************** '*************** 'Open connection '*************** sub OpenDB 'Instantiate obj vars set conn = Server.CreateObject("ADODB.Connection") set command = Server.CreateObject("ADODB.Command") set rs = Server.CreateObject("ADODB.RecordSet") 'Open DB 'conn.Open "advertisementDB" conn.Open "Provider=SQLOLEDB;Data Source=ROBERTODELL;Initial Catalog=Advertisement;User ID=sa" end sub '******************************* 'Setup Specific Stored Procedure '******************************* sub SetupProcedure(com, strProcName) 'Setup procedure com.ActiveConnection = conn com.CommandType = adCmdStoredProc com.CommandText = strProcName com.Parameters.Refresh end sub '******** 'GetField '******** function GetField( FieldName ) on error resume next 'Prevent exception 'Invalid Use of Null 'Marcio 08/07/2003 11:30 PM if IsNull(rs(FieldName)) or IsEmpty(rs(FieldName)) then GetField = CStr("") else GetField = rs( FieldName ) end if 'If error, return it if err.number <> 0 then strMessage = "* " & err.Description strFlow = "Error" GetField = "" end if end function '****** 'Delete '****** sub Delete on error resume next 'Optional parameters (do not fill out optional parameters, procedure will make it NULL) if request.form("hdnOrganizationID") <> "" then command.Parameters("@OrganizationID") = request.form("hdnOrganizationID") end if if session("OrganizationID") > 0 then command.Parameters("@OrganizationID") = session("OrganizationID") 'Will be null when inserting end if 'Execute command... be ready to display exceptions generated by DB command.Execute 'If an error happened in DB if err.Number <> 0 then strFlow = "Error" 'This will force form to load previous values strMessage = "* " & err.Description 'No errors in DB else 'If save and new, reset client id and reload form if strFlow = "Delete" then session("OrganizationID") = 0 end if 'Display form and message... successfully updated strMessage = "Organization successfully deleted." end if 'Always display the form. GetField() and GetLookup() will know from where to populate DisplayFormAfterDelete end sub '***************** 'PopulateForDelete '***************** sub PopulateForDelete on error resume next 'Fill parameters and Execute command command.Parameters("@OrganizationID") = session("OrganizationID") 'Execute command... be ready to display exceptions generated by DB set rs = command.Execute 'If an error happened in DB if err.number <> 0 then strFlow = "Error" 'This will force form to load previous values response.write "<center><br><font color='red'>" & err.Description & "</font></center>" end if end sub '**************** 'Close Connectoin '**************** sub CloseDB 'Close DB when state is not adStateClosed if rs.State <> 0 then rs.Close if command.State <> 0 then command.Close if conn.State <> 0 then conn.Close 'Release mem set rs = nothing set command = nothing set conn = nothing end sub '************ 'Display Form '************ sub DisplayForm %> <html> <head> <title>Advertisement System - Delete Organizations</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <script language="javascript"> // T r i m ! ! ! function trim( inputString ) { // Removes leading and trailing spaces from the passed string. Also removes // consecutive spaces and replaces it with one space. If something besides // a string is passed in (null, custom object, etc.) then return the input. if( typeof inputString != "string") return inputString; // Vars var retValue = inputString; var ch = retValue.substring(0, 1); // Check for spaces at the beginning of the string while( ch == " " ) { retValue = retValue.substring( 1 , retValue.length ); ch = retValue.substring( 0 , 1 ); } // Check for spaces at the end of the string ch = retValue.substring( retValue.length - 1, retValue.length ); while( ch == " " ) { retValue = retValue.substring(0, retValue.length-1); ch = retValue.substring(retValue.length-1, retValue.length); } // Note that there are two spaces in the string - look for multiple spaces within the string while( retValue.indexOf(" ") != -1 ) // Again, there are two spaces in each of the strings retValue = retValue.substring(0, retValue.indexOf(" ")) + retValue.substring(retValue.indexOf(" ")+1, retValue.length); // Return the trimmed string back to the user return retValue; } // Performs validation and submits the form function Validate( action ) { if (action == 'No') { // Ready to submit Organization.hdnFlow.value = action; Organization.submit(); return; } // Ready to submit Organization.hdnFlow.value = action; Organization.submit(); } </script> <body bgcolor="#FFFFFF" text="#000000"> <center> <table width="800" border="0" cellpadding="0" cellspacing="0">  <tr> <td width="800" height="23" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: x-small; color: Black;"> <tr> <td width="21" height="23"></td> <td style="font-weight: bolder; font-size: small; font-variant: small-caps; "> Welcome <%= session("AdminName") %>! </td> <td width="461"></td> <td width="93" valign="top"> <div align="right"><font face="Arial, Helvetica, sans-serif"><b><font size="3"><a href="..\login.asp"><font size="2">LogOut</font></a></font></b></font></div></td> <td width="22"></td> </tr> </table></td> </tr> </table> <br>  <form id="Organization" method="post" action="Organization_D.asp" name="Organization"> <table align="rigth" width="100%" border="0" cellpadding="1" cellspacing="1" halign="right" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: xx-small;">  <tr> <td width="89" height="15"></td> <td width="204"></td> <td width="369"></td> <td width="83"></td> </tr> <tr> <td height="25"></td> <td align="right" valign="center"> <font face="Arial, Helvetica, sans-serif" size="2" color="red">*</font> Name</td> <td valign="middle"><%= GetField("Name")%> </td> <td></td> </tr> <tr> <td height="23"></td> <td align="right" valign="center">Activity</td> <td valign="middle"><%= GetField("Activity")%></td> <td></td> </tr> <tr> <td height="23"></td> <td align="right" valign="middle">Contact First Name</td> <td valign="middle"><%= GetField("FirstName")%></td> <td></td> </tr> <tr> <td height="23"></td> <td align="right" valign="middle">Contact Last Name</td> <td valign="middle"><%= GetField("LastName")%> </td> <td></td> </tr> <tr> <td height="23"></td> <td align="right" valign="middle">Contact Email</td> <td valign="middle"><%= GetField("Email")%></td> <td></td> </tr> <tr> <td height="34"></td> <td> </td> <td></td> <td></td> </tr> <tr> <td height="45"></td> <td colspan="2" align="center" valign="middle" > <input name="hdnFlow" type="hidden" id="hdnFlow2"> <input type="hidden" name="hdnOrganizationID" > Are you sure you want to delete this record? <br> <input name="btnYes" type="button" style="cursor:hand" onClick="Validate('Yes')" value="Yes"> <input type="button" name="btnNo" onClick="Validate('No')" value="No" style="cursor:hand" > </td> <td> </td> </tr> <tr> <td height="24"></td> <td> </td> <td></td> <td></td> </tr> </table> </form>  </center> </body> </html> <% end sub sub DisplayFormAfterDelete %> <html> <head> <title>Advertisement System - Deleted</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF" text="#000000"> <center> <script language="JavaScript"> // Performs validation and submits the form function validate( action ) { if (action == 'No') { // Ready to submit Organization.hdnFlow.value = action; Organization.submit(); return; } } </script> <br> <table width="778" border="0" cellpadding="0" cellspacing="0">  <tr> <td width="778" height="40" valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0" style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: x-small; color: Black;">  <tr> <td width="21" height="36"></td> <td width="236" valign="top" style="font-weight: bolder; font-size: small; font-variant: small-caps; "> Welcome <%= session("AdminName") %>! </td> <td width="313" align="left" valign="middle" id="msgMessage" style="font-weight: normal; font-size: xx-small;color: red; font-family: verdana,tahoma,monospace; ">  <%= strMessage%> </td> <td width="208" valign="top"> <div align="right"><font face="Arial, Helvetica, sans-serif"><b><font size="3"><a href="..\login.asp"><font size="2"> LogOut</font></a></font></b></font></div></td> </tr> <tr> <td height="4"></td> <td></td> <td></td> <td></td> </tr> </table></td> </tr> </table>  <form id="Organization" method="post" action="Organization_D.asp" name="Organization"> <br> <font style="font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: xx-small;">Go to Organization Browser </font> <br> <br> <input name="btnGo" type="button" onclick="validate('No')" style="border-bottom-style: groove; border-bottom-width: thin; border-left-style: groove; border-left-width: thin; border-top-style: groove; border-top-width: thin; border-right-style: groove; border-right-width: thin; cursor:hand; background-color: #ADD8E6;" value="Go"> <input type="hidden" name="hdnFlow" > <br> <br> <br> <br> <br> <br> <br> </form>  </center> </body> </html> <% end sub '******* 'M A I N '******* 'Verify if login is not expired CheckLoginSession 'Get the flow information from hidden field if request.form( "hdnFlow" ) <> "" then strFlow = request.form( "hdnFlow" ) else strFlow = "Confirm" end if 'Get the affiliateid from querystring if request.querystring( "id" ) <> "" then session( "OrganizationID" ) = CInt(request.querystring( "id" )) 'strFlow = "Confirm" end if '**************************************************** 'Understand the navigation flow controlled by strFlow ' ' "Delete : Blank form - GetField returns blanks. Thus, load form with blanks ' "Error" : Will populate form like in "Delete", based in response.form() ' '**************************************************** select case strFlow 'Yes case "Yes", "Delete" OpenDB SetupProcedure command, "dOrganization" Delete CloseDB ' Error or Update case "Confirm", "Error" OpenDB 'If delete, populate form to confirm if strFlow = "Confirm" then SetupProcedure command, "sOrganization" PopulateForDelete end if DisplayForm CloseDB ' When user choose No, it backs to the Affiliate browser case "No" response.redirect"brw.asp?sbj=Organization" end select %> Thanks in advance Roberto Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141827
  - 5
    - VBScript Word Automation Table Error Hi all, I'm using VBScript to create a Word doc from a web page. Everything was going fine until I tried to add a table to the doc, then I get an error which I can't account for. This is my code: function test dim oWord dim oDoc set oWord = CreateObject("Word.Application") oWord.Visible = True oWord.Documents.Add set oDoc = oWord.ActiveDocument oDoc.PageSetup.Orientation = 1 oDoc.Tables.Add Range:=oWord.Selection.Range, NumRows:=2, NumColumns:=3 oWord.Selection.TypeText "Ben was here" set oWord = nothing end function This runs fine if I comment out the oDoc.Tables.Add line. I have tried approaching the tables call from all directions, eg. oWord.ActiveDocument.Tables.Add, as well as the Range call, with no luck. I'm running IE6 and Office XP. Any help would be greatly appreciated :o) Regards, Ben Empson -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141815
  - 6
    - Disabling CANCEL button during shell file copy -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm using the following script to copy files which provides a copy progress dialog box. What I want to do is disable the CANCEL button during the copy. Does anyone know of any way to do this? Thanks, Chris SCRIPT: 'Respond with "Yes to All"(16) + Display dialog but no files(256) + Do not confirm the creation of directory(512) Const FOF_CREATEPROGRESSDLG = 784 ParentFolder = "D:\DATABACK" Set objShell = CreateObject("Shell.Application") Set objFolder = objShell.NameSpace(ParentFolder) objFolder.CopyHere "D:\TESTING", FOF_CREATEPROGRESSDLG -----BEGIN PGP SIGNATURE----- Version: PGP 8.0 Comment: Public PGP key for Chris Lynch iQA/AwUBP0uLDG9fg+xq5T3MEQIBiACfbvKo6gvf6s4eLrlVbdxRuy6QUGUAnRJD 08BGtfO9xjqlWQqF1sTxHYfL =7O0m -----END PGP SIGNATURE----- Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141806
  - 7
    - username and computer name in vbscript/asp/java/wsh? Hi, I have seen this topic come up many times but have never really seen a concise answer to the problem. Basically what I have is an asp page that is using ado to do some database queries. I have an activity log table in my database that I would also like to update when certain events are triggered on the webpage. In this activity log I wanted to have the network username and the computer name of the person that was using the webpage. I thought VBScript would be best for this because it runs client-side but I have not found a solution yet. Though this webpage will be running on my company's intranet, we are a company of 6000 and I have absolutely NO control over the server it will be running on. Any help would be awesome. Thanks! -Jeremy Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141805
  - 8
    - transfering data from .csv to .xls Hi, I am using Activex scripts in SQL Server DTS Packages to read from a .csv file and write it to a Excel file. The actual problem is the leading zeroes are being truncated in the XL file. Hence, I use ActiveSheet.QueryTables.Add method to define the formating properties that I require. It creates the Excel file successfully but it neither transfers the data nor does it format the cells. Below is my code. Pls. let me know if I am going with the right approach. VERY URGENT. If any of you can suggest me an alternate way on how I can transfer the data from .csv to .xls without loosing the leading zeroes, I would be really grateful. with regards, Ram Function Main() Dim Xcl Dim strDestinationFileName Dim strSourceFileName 'strDestinationFileName = "D:\_Clients_Data\Monument\Order\vipul2.xls" strSourceFileName = DTSGlobalVariables ("Data_File_Path")&DTSGlobalVariables("Data_File_Name") strDestinationFileName = DTSGlobalVariables ("Schema_File_Path")&DTSGlobalVariables ("Schema_File_Name") Set Xcl = CreateObject("Excel.Application") Xcl.Visible = true Set newBook = Xcl.Workbooks.Add newBook.Worksheets(1).Name="My First WorkSheet" newBook.Worksheets(2).delete newBook.Worksheets(2).delete newbook.Worksheets(1).Activate 'importing the .csv file With ActiveSheet.QueryTables.Add (Connection:= "TEXT; D:\_Clients_Data\Monument\Order\09- 03_Order_Monument.csv", Destination:= Range ("A1") ) .Name = strDestinationFileName .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = False .TextFileSemicolonDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) .Refresh BackgroundQuery:= False End With newBook.SaveAs strDestinationFileName Xcl.Visible = false Set Xcl = nothing Main = DTSTaskExecResult_Success End Function Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141804
  - 9
    - writing text file in ASP hello All. i am using the FSO to write a text file derived from a database.. see code. however i am getting a 'permission denied' error message: Error Type: Microsoft VBScript runtime (0x800A0046) Permission denied /invoice/nv_rebuild.asp, line 101 what an i doing wrong here?.. or maybe someone has some example code that works!. Help!.. _____code starts here________ <%@ LANGUAGE="vbscript" %> <% Option Explicit Response.Buffer = TRUE Dim strSqlTxt Dim strInvoiceNo Dim strInvoiceDate Dim strDivisionCode Dim strCustCode Dim strLaborHours Dim strLaborCost Dim strEstimateNo Dim strAmount Dim strEquipNo Dim strWorkOrderNo Dim strMaterialCost Dim strEstimateLaborHours Dim strEstimateLaborCost Dim strEstimateMaterialCost Dim strTotalWorkCost Dim conntemp Dim rstemp Dim strStreamLine Dim objFSO Dim objTStream Dim objFileObject RebuildInvoices() Sub RebuildInvoices() SetSqlRebuildInvoices() OpenInvoiceConnect() Do Until rstemp.EOF SetInvoiceValues() WriteValues() OpenOutFile() StreamOutFile() rstemp.MoveNext Loop objTStream.Close CloseInvoiceConnect() End Sub Sub SetSqlRebuildInvoices() strSqlTxt = "SELECT " strSqlTxt = strSqlTxt & "a.invoice_no, " strSqlTxt = strSqlTxt & "a.invoice_date, " strSqlTxt = strSqlTxt & "a.division_code, " strSqlTxt = strSqlTxt & "a.cust_code, " strSqlTxt = strSqlTxt & "a.labor_hrs, " strSqlTxt = strSqlTxt & "a.labor_cost, " strSqlTxt = strSqlTxt & "a.material_cost, " strSqlTxt = strSqlTxt & "a.amount, " strSqlTxt = strSqlTxt & "b.estimate_no, " strSqlTxt = strSqlTxt & "b.work_order_no, " strSqlTxt = strSqlTxt & "c.equip_no, " strSqlTxt = strSqlTxt & "c.labor_hrs AS estimate_labor_hours, " strSqlTxt = strSqlTxt & "c.labor_cost AS estimate_labor_cost, " strSqlTxt = strSqlTxt & "c.material_cost AS estimate_material_cost " strSqlTxt = strSqlTxt & "FROM " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.invoice_header A, " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.work_order B, " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.equip_damage_list C " strSqlTxt = strSqlTxt & "WHERE " strSqlTxt = strSqlTxt & "a.invoice_no BETWEEN '310801' AND '310850' " strSqlTxt = strSqlTxt & "AND a.invoice_no = b.invoice_no " strSqlTxt = strSqlTxt & "AND c.estimate_no = b.estimate_no " strSqlTxt = strSqlTxt & "ORDER BY " strSqlTxt = strSqlTxt & "a.invoice_no " End Sub Sub SetInvoiceValues() strInvoiceNo = rstemp("invoice_no") strInvoiceDate = rstemp("invoice_date") strDivisionCode = rstemp("division_code") strCustCode = rstemp("cust_code") strLaborHours = rstemp("labor_hrs") strLaborCost = rstemp("labor_cost") strMaterialCost = rstemp("material_cost") strAmount = rstemp("amount") strEstimateNo = rstemp("estimate_no") strWorkOrderNo = rstemp("work_order_no") strEquipNo = rstemp("equip_no") strEstimateLaborHours = rstemp("estimate_labor_hours") strEstimateLaborCost = rstemp("estimate_labor_cost") strEstimateMaterialCost = rstemp("estimate_material_cost") strTotalWorkCost = Cint(strEstimateLaborCost) + Cint(strEstimateMaterialCost) End Sub Sub OpenOutFile() Set objFSO = Server.CreateObject ("Scripting.FileSystemObject") Set objTStream = objFSO.CreateTextFile ("C:\downloads\invoice.txt", True, False) End Sub Sub StreamOutFile() strStreamLine = strInvoiceNo & strInvoiceDate & strDivisionCode & strCustCode & strLaborHours & strLaborCost & strMaterialCost & strAmount & strEstimateNo & strLaborCost & strAmount & strWorkOrderNo & strEquipNo & strEstimateLaborHours & strEstimateLaborCost & strEstimateMaterialCost & strTotalWorkCost objTStream.Writeline strStreamLine End Sub Sub WriteValues() response.write strInvoiceNo response.write strInvoiceDate response.write strDivisionCode response.write strCustCode response.write strLaborHours response.write strLaborCost response.write strMaterialCost response.write strAmount response.write strEstimateNo response.write strLaborCost response.write strAmount response.write strWorkOrderNo response.write strEquipNo response.write strEstimateLaborHours response.write strEstimateLaborCost response.write strEstimateMaterialCost response.write strTotalWorkCost response.write "<br>" End Sub Sub OpenInvoiceConnect() set conntemp = server.createobject("adodb.connection") conntemp.Open "Provider=sqloledb;Data Source=GBLSQL;Initial Catalog=tradedepot;User Id=tradedepot;Password=tradedepot" set rstemp = conntemp.execute(strSqlTxt) End Sub Sub CloseInvoiceConnect() rstemp.Close Set conntemp = NOTHING End Sub %> _______code ends here _______________ Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141799
  - 10
    - Highlight Text in Control Greetings, I am not sure if this is possible, but within ArcPad Studio 6.0.1.2OU (ArcPAd is basically pared down desktop GIS software for PDAs). I am doing my development on a Windows 2000 machine, but the resultant code is placed on an IPaq handheld. I have an edit control in a form. The control is bound to a DBF file and shows data if it is populated or "0" (integer field in the DBF) if it is not. I want to be able to highlight whatever text is in that control (i.e. background of selected text is navy blue, the text is white, and the caret/cursor is all the way to the right of the selected string). The tools that are being written are for handheld devices that field workers will be utilizing with a stylus. The fewer the clicks/taps they must make with the stylus, the more efficient their use of our tool. Any idea then, on how to highlight text in a VBScript edit control ? Best regards, Jason Ramirez ...I know, I'm garrulous :) Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141791
  - 11
    - Could not load type '****.Global' I'm working my way through the .net Mappoint Web services sample code, but I keep experiencing this error - "Could not load type '****.Global'" (where **** is the application name). I've had a look through the news group for similar problems but I've had no luck with of the suggested solutions. For the record I've checked that the projects been built, the web service is correctly named and the application is set up in IIS. Any other suggestions? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141786
  - 12
    - Output PDF I have the following code ... Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Dim fso, f, ts Set fso = CreateObject("Scripting.FileSystemObject") strPhyPath = Server.MapPath("/paysonnelCE/Misc/Bernard") Set f = fso.GetFile(strPhyPath & "\test.pdf") Set ts = f.OpenAsTextStream(ForReading, TristateUseDefault) Response.Buffer = True Response.ContentType = "application/pdf" Response.BinaryWrite ts.ReadAll Response.Flush the purpose is to stream a pdf to client... but all I get is the details, ascii codes of the pdf ... anyway I can get a pdf instead of ascii text display ? Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141782
  - 13
    - Remote comuter access + FileSystemObject? Hi! :-) I'd like to know if it's possible to access the FileSystemObject on a remote machine. In this case to check the remainging space on the HDs of my file server. Right now I can only access the local machine with: Set objFileSystem = CreateObject("Scripting.FileSystemObject") For Each objDrive In objFileSystem.Drives If objDrive.DriveType = 2 Then 'Local Disc WScript.Echo objDrive.Path WScript.Echo "Size: " & objDrive.TotalSize WScript.Echo "Free: " & objDrive.FreeSpace ... End If Next And check the directory sizes with: Set objFolder = objFileSystem.GetFolder(strPath) WScript.Echo strPath & " " & objFolder.Size Is it at all possible to do this on a remote mashine and if so, how? Thanks a million! :-) /Sofia Engvall AB Ångpanneföreningen Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141781
  - 14
    - convert an html form post to a script Hi I have a form that posts to a CGI script. I would like to automatically send multi posts to the CGI Script. Can anyone point me in the direction of how to I can emulate the form post from inside a Script? Regards and Thanks!!! Meir Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141780
  - 15
    - How to delete all jobs in a print queue by vbs? Hi there, Does anyone know how to delete all jobs in a print queue by vbs? When I restart one of my Company's printer, all old print jobs will print again, so I want to write a script to fix it. Thank you in advanced. Regards, Stanley Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141775
  - 16
    - find a string in a file Hello, I am writing a VBString, what is the fastest way to open a file and search a string and read a few characters after that string? Thanks, Jim. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141768
  - 17
    - Displaying line number with custom error message? Hello; I'm trying to create a custom error capturing function that writes VBScript errors to the computer's Event Log. I've been able to do most of what I want so far, but I can't figure out how to write the line number of where the error occurred... is that even possible? Sincerely, Todd M. Taylor Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141760
  - 18
    - How to read a text file from web server Hi guys, Does anybody know how to read a text file from web server? For example, read test.txt file from: http://abc/test.txt Any comments will be highly appreciated. Thanks Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141755
  - 19
    - Computer name Hello all, I want to use a list of computers that I have serial numbers and corresponding asset numbers for to rename the computers. I have the compname.exe that works great but want to go a step further. Is there a way to have vbscript detect the serial number of a computer then use a list that associates a different name to the serial number and have the script rename based on that? Step 1: Identify & Capture serial number Step 2: Compare serial number to list ie serial number asset number 123456 abcdefg Step 3: Rename the computer so that if serial number = 123456 then computername = abcdefg. Thanks in advance for any help. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141753
  - 20
    - [newbie] Status of ActiveX-based web apps? Hi, We're currently checking out all our options to move from VB-written dedicated apps to web applications, and that obviously includes pages that include ActiveX and VBScript. I took a look on Amazon, and noticed the dearth of books on the subject. Hence my question : Apart from the fact that the ActiveX + VBScript is an MS-only solution (which is not an issue with our customers)... why so much exposure for Java or .Net, and so little for this alternative? Are there technical issues that we'll see later as we investigate further? Thx for any feedback JD. Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141751
  - 21
    - Copy folder and progress bar. Does anyone know of an efficient way of reporting the status (% complete) of the folderobject.copy method? I'm using the following to copy fair amounts of data (700 - 1000 Mb) in a complexe directory structure. ******************* Set fso = CreateObject("Scripting.FileSystemObject") Set folderObject = fso.GetFolder("D:\somepath") folderObject.Copy "e:\",TRUE ****************** I need to be able to show progress in either a progress bar or at the vey least by feeding a percentage completed to a log windows.(wihich I already have built using IE and an hta form. Thanks Pierre Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141749
  - 22
    - WSH 5.6 debugging is available now! Script Debugger IDE supports WSH debugging now! New features you can see here: http://www.script-debugger.com/products/scrdebugger/debugwsh.asp Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141743
  - 23
    - Script problems (write routine) Hello I have a VBScript that sometimes works fine but often sucks - problem in combination with WSH? 1st here is the part of the script making trouble: (note: following URL is an example) private function writefile() GetURL = www.someurl.com\index.php3?TYPE=Right Dim Http Set Http = CreateObject("Microsoft.XMLhttp") Http.Open "GET",GetURL,False Http.Send HtmlResult = Http.ResponseText HtmlResult = right(HtmlResult, len(HtmlResult) - instr(HtmlResult, "")) HtmlResult = left(HtmlResult, len(HtmlResult) - instr(HtmlResult, "</body>")) Set Http = Nothing set fs=CreateObject("Scripting.FileSystemObject") set f1=fs.CreateTextFile("test.tmp",true) f1.write(HtmlResult) f1.close set f1=nothing set fs=nothing writefile = "Tempfile written." end function OK however the script only works when: - I installed WSH 5.6 (is there a localized version oder only english?) and reboot - and run this script (in a Application supporting VBS-files) and it works fine but - after next reboot the Script terminates and also the application script is running in terminates unexpected without promting or an failure message. Only when I re-install the WSH and after 1st reboot script also works. So is this a WSH-Bug or where's the problem? Note: I guess, the problem is the .write - routine because when the script terminates, no such file has been written. Kind regards, Torsten -- "Outside is where the pizza comes from" Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141738
  - 24
    - Generalized Time How to read out the AD-property "createTimeStamp" (data type GeneralizedTime) of an user object and convert to a readable string like dd/mm/yyyy ? Thanks for help Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141733
  - 25
    - send SMS Hi at all! Could anyone to say me how to send SMS using ASP/VBSCRIPT page? Thanks Tag: Import a csv-file into MS access with the aid of vbScript Tag: 141730

Hi,

Can someone give me a hand howto import an text/csvfile into access
with vbscript?

I have gather some loggings of arcserve from several of our
shop-servers in one 500k csvfile.

I tried working with Excel (also with vbscript) and it worked:
importing.

The spreadsheet was some 5000 rows. I wanted to use autofilter to make
a few selections, BUT the autofilter-function works only with appr.
2700 rows, so I had to find another way to Display de loggings...

So, I am NOT looking for VBA code but for vbscript code

And if you can tell me how to run/make a macro within Access that
would make me (and some of my collegues) very glad..

Tia,

André

Top

Re: Import a csv-file into MS access with the aid of vbScript by Bryan

Bryan
Fri Aug 29 12:16:54 CDT 2003

Post part if large or all of your file and I will try to help.

"Andre vWG" <avwg@planet.nl> wrote in message
news:91083919.0308290751.21f5124e@posting.google.com...
> Hi,
>
> Can someone give me a hand howto import an text/csvfile into access
> with vbscript?
>
> I have gather some loggings of arcserve from several of our
> shop-servers in one 500k csvfile.
>
> I tried working with Excel (also with vbscript) and it worked:
> importing.
>
> The spreadsheet was some 5000 rows. I wanted to use autofilter to make
> a few selections, BUT the autofilter-function works only with appr.
> 2700 rows, so I had to find another way to Display de loggings...
>
> So, I am NOT looking for VBA code but for vbscript code
>
> And if you can tell me how to run/make a macro within Access that
> would make me (and some of my collegues) very glad..
>
>
> Tia,
>
> André

Top