Search results for query: *

Perfect that worked. The only other thing the end users are asking for is to have a log file of the number of lines processed rather than a msgbox.

Couldn't get it to work. tried using the GetFile method in gtghe SetFile line and the CreateFile method for the Set OutPutFile still doesn't work. Set FSO = CreateObject("Scripting.FileSystemObject") strInputDir = "C:\TEST\" strOutputDir = "C:\TEST2\" ForReading = 1 ForWriting = 2 intNum = 0...

thanks for the quick reply. I changed the paths and ran from the cmd line and nothing happened. Was there something else I needed to do? Again, thanks so much

I have a simple VBScript that looks for a file called test.txt replaces the "|" with a "," and names the file test2.txt. What I want to do is have the script look at any .txt files in the current directory, create the outputfile in a different directory and name it "ProcessedFile" with a...

I have an Access 2010 table that is linked to a SharePoint 2010 list. I am using this table as a datasource for a line of business application. the porblem I just found out is the LOB cannot use a linked table. So I was wondering how I could automate the copy of the data from the linked table to...

Thanks just what i needed.

Interesting, so I could use MS Access to load a text file into SQL Server and populate a SP list? But shouldn't use SQL Server import utility?

I have a client that has created an HR repository using WSS 3.0. He has created an employee list and manually enter some of the employees. The company's HR application is hosted off site, so the client is asking how to automate the daily import of a flat file to the HR list in SP. Is this...

I am trying to create a new connection with CR11 and a .csv file. While using the database expert I am able to create my source, but when i browse the data, i get nothing but invalid characters. I have gone through the steps multiple times so I am fairly sure i am doing it right. Any advice...

thanks lbass. worked perfectly

Ok I can use a selection formula. What i want to have happen is if a row contains "System created" then it is eliminated.

I have a report in version 11 that uses a .xls as it's data source. I would like to remove or supress rows based when certain specific data appears in that row. Also, if a certain row is blank, then i would also like to remove it from the details and any totals. Tried it with a formula in the...

Hi trying to create a simple formula that is applied based on certain group membership. Datasource is a .csv file. If memeber of group then apply formula otherwise ignore. Here is code so far: if {ReportExport_csv.cGroupName} StartsWith 'agent' then {ReportExport_csv.cBWPages} - 800 else...

Thanks John, I was not using enough ".

I need to format a column and add "" around each value in the cloumn. I am thinking there must be some formula that would do this. Any help would be greatly appreciated

George, worked perfectly thanks.

George, Yes the logic works as intended. How do I then update the column with the formatted values? Thanks, Lou

I have a SQL server 2005 table with a varvhar(50) column that is populated with values ranging from 01 to 9999. I would like to pad each row to 5 characters with leading 0's and then prepend the column with CP so that so that all data in that column is 7 characters in the following format...

I have the following simple SP running on an SQL 2005 Standard edition server.: CREATE proCEDURE dbo.sp_UPDATE_CLE_RECORDS AS UPDATE c SET Last_Name = m.MLNAME, First_Name = m.MFNAME, Middle_Name = m.MMNAME, Prefix = m.MPREFIX, Suffix = m.MSUFFIX FROM cle c, MEMBER M WHERE C.MID...

Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456 Error state: 1, Severity: 14 Source: Microsoft OLE DB Provider for SQL Server Error message: Login failed for user 'NT AUTHORITY\SYSTEM'. Any help would be greatly...