Recent content by QLearnerNow

for some reason SQL ent manager has stopped working on my server. SQL is up anmd running but I cannot get ent manager to work, I get the following error: MMC cannot open the file c:\program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC This may be because the file...

Hi guys, I have an array ColWidths = split("141|51|40|50|60|61|61",DELIM) when I pass this to a function CreateReport(aManagedFunds, ColWidths, True)) and try to access the individual elements of ColWidths Function CreateReport(aData, ColWidths, HasBorder) Dim Rows, Cols, Row...

thank you shall try there

QLearnerNow (Programmer) Aug 26, 2003 Hi Guys, I have created a recordset to a csv file. The csv file has an field called account number. some of the values in account number exceeds the integer data type capacity. The recordset retrieves these values as Nulls. How do I get around this...

rsNav("InvestorAccNum") this is returning an int im not doing any conversion to int not using Cint anywhere. rsNav("InvestorAccNum") just seems to come as an int. im trying to use this statement now rsNav.Source = "SELECT CAST(InvestorAccNum AS nvarchar)AS Acc FROM...

Dim rsNav, ClientID, strSql Dim rsNav_numRows FileCleanse Set rsNav = Server.CreateObject("ADODB.Recordset") rsNav.ActiveConnection = MM_CMT_STRING rsNav.Source = "SELECT * FROM NavigatorCleanse.csv Order By InvestorAccNum" rsNav.CursorType = 0 rsNav.CursorLocation = 2...

Hi Guys, I have created a recordset to a csv file. The csv file has an field called account number. some of the values in account number exceeds the integer data type capacity. The recordset retrieves these values as Nulls. How do I get around this problem. Is there anyway I can read the...

SqlSister I just tried this SELECT * FROM OPENQUERY(Serv, 'spColumns Comp1') and I get this error Server 'Serv' is not configured for DATA ACCESS. Serv is the name of the SqlServer

This is what I tried SQL Sister SELECT * FROM EXCEL...Trust$ This is the error message I get Server: Msg 7314, Level 16, State 1, Line 1 OLE DB provider 'EXCEL' does not contain table 'Trust$'. The table either does not exist or the current user does not have permissions on that table. OLE...

Here is what I tried SQLSister: sp_addlinkedserver N'Excel', N'Jet 4.0', N'Microsoft.Jet.OLEDB.4.0', N'c:\Names.xls', NULL, N'Excel 8.0' GO sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL GO SELECT * FROM EXCEL...Trust$ GO Here is the error...

what about the OPENDATASOURCE T-SQL command James. I dont have to use a csv file I can also use an excel file. I have tried using the OPENDATASOURCE command but even that doesnt work says cannot find object

Hi guys, I want to query an excel file using OPENDATASOURCE command from my Query Analyser. I want to do this without using a linked server. OPENDATASOURCE seems to be the right command but when I give this command in query analyser SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0'...

wrong answer simma

Hi Guys, I want to be able to write an SQL Select statement that returns records from Table1 that are not present in rec.csv file. how can I do this using Query Analyser? is this possible? Thanking you QLearnerNow

what if you just say dim FileName FileName = ActiveSheet.Range("I7").Value & ".xls" ActiveWorkbook.SaveAs "S:/WGSpecChemOps/QC Analytical/Facility 2/CERTS/2003/" & FileName I have never done excel programming so please forgive me if it doesnt work Regards...