Recent content by cardiac

Found the following info while trawling through forums for answers: Try adding SET NOCOUNT ON as the first statement after AS in your procedure script. Without that, either ADO or DAO will see the rowcount returned from the first select, and think the procedure has completed before a result is...

Thanks but when I tried this I still get exactly the same error message.

I am having trouble passing parameters via excel vba to a stored proceudure in MS SQL server 2005. The code is as follows: - Sub Get_RowData(TeamName As String, sheetname As String, rownum As Integer) Dim SQLcmd As String Dim fromDate As String Dim toDate As String Dim strTeam...

Thanks - I managed to get it working with the following code: <?php do { ?> <table width="612" border="1" align="center"> <?php $news_link="docs/".$row_rsNews['doc_name']; ?> <tr> <td width="95" align="center"><?php echo $row_rsNews['date']; ?></td> <td...

I have created a web page that consists of a repeating region from a database. The resulting table gives the details of a server stored document. The columns are: the date the document was stored,the document title, and a final 3rd column. I want this 3rd column to contain an icon of either a...

Thanks to everyone for trying.

Have you missed 'Next X' ? For X = 1 To Y With Range("C" & X).Select If Range("C" & X).Value <= 1 Then Range("C" & X).EntireRow.Delete End If End With Next X

It should create both the new workbook automatically - but it does neither. The $ is definately not required - it does not work with or without at the moment. I have created the empty workbook manually and just atempted to export to it - but this does not work either.

Thanks - but still no joy. Yes, I do want to create a new workbook with the sheet 'Test' in it. The Microsoft site says you must not use a '$' sign for sheets reference by the INTO clause and that the sheet to write to must NOT already exist in the workbook. so I tried: - sSql = "SELECT * INTO...

This is my code - which does not work! Set rsExcel = New ADODB.Recordset sConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\test.xls ";Extended Properties=Excel 8.0;" sSql = "SELECT * INTO [Test] IN C:\test.xls FROM [Sheet1$]" rsExcel.Open sSql, sConnect, adOpenDynamic...

I actually WANT to use SQL - I know how to copy a sheet to a workbook. I dont actually want to open a new workbook hence the SQL. Ther are actually other reasons which I dont need to go into here.

There is nothing in the unopened workbook that I want to export to - I just need to export the modified data to a new workbook

I probably did not explain very well.... I have code which requests the user to choose several files to import data from (SQL connection). The imported data is then manipulated. (The code for this works fine). I then want to be able to select an Excel workbook to export the manipulated data...

How do I export data from a sheet in an open workbook to another sheet in a closed wokbook using SQL?

Hi, I'm using VBA to create an approval workflow. Each user has their own (default) Outlook Information store (e.g. "Mailbox - Bloggs, Joe") which is a .pst store. In addition, they all have shared access to an Exchange Server store ("Mailbox - Inspection"). When they click a button, creating...