Recent content by WilliamMathias

Hi Thank you all, I used Remy's version and it worked. Cheers, Will

Hi chad, Could you post your piece of code that opens the recordset and sets up the connection thanks for your help Will

Hi, I'm using an ADO link to excel and I can read from the Excel file OK, but has anyone successfully written to an Excel file using ADO? (I've previously used Automation but I've had problems with leaving instances of Excel running, despite explicitly closing them down!) Cheers Will

Hi, thanks for your replys: 930Driver: I've not been clear enough. I want to say: WHERE dealtypeID = 1 or 2 (using a parameter) not WHERE [parameterImPassing] = 1 or 2 WildHare: If I built a SQL criteria string as you suggest could I pass it as a parameter, rather than using it as a...

Hi, I've got a make table query which is passed a parameter parDealType of type integer. For various reasons I can't use a where clause. I want to pass a value for parDealType of "1 or 2" My query works fine if I'm passing just 1 My query works fine if I'm passing just 2 but if I...

Hi. The following code will not work? When I execute the command I get run time error -2147467259 (80004005): Cannot execute a select query Can I run an excel subroutine through ADO? I've previously used OLE automation to do this but I've found it very troublesome. Thaks in advance...

Hi, I've just installed Visual Source Safe 6. Its working fine I've got Access 2000 installed OK Its working fine When I open the addin manager in ,say, VB 6, source safe appears as one of the available addins. But, When I open the addin manager in access, there are no available add ins...

Hi, The following is an extract that hopfully answers your question: Another type of system table isn't really a table; it's a pseudo-table. Pseudo-tables take up no space and aren't stored permanently on disk. Instead, SQL Server builds them dynamically every time you query them. Storing...

Hi, In my experience I've found thart using ANSI SQL wherever possible is less problematical, and more universally useful I'd also like to reccomend the same book as jitter, it helped me loads. good luck Will

Hi, Your transaction isolation level determines your level of locking. Default is Read Committed. See this article for further details. http://www.sqlmag.com/Articles/Index.cfm?ArticleID=5445 Will

Hi, A big thank you to Skip,Dale,Ted and Ilses :) I used Ted and ilses range method and it worked a treat! My import routine now works 2 1/2 times faster! I'm now just selecting the columns that I need. Cheers, Will

Skip & Dale, I have a version that works by processing the data in Access. To move this processing to Excel would achieve little. Re: ODBC This is another method of reading data from a remote data source, an alternative to ADO, however the problem I have would not be fixed by swapping my...

Hi Skip, Yuor solution would work exellently, if I were workinmg from within Excel, but without using OLE Automation (which is v slow and awkward) or running the macro remotely, I can't run code in excel. Also I'm limited in the changes I can make to the excel sheet, so I'd like to do the...

Ideally just a selection of rows, but if you can show how to name some columns, instead of all I'd be half way there. If you have experience of SQL, what I'd really like to do is the following: SELECT colA, colB, colD FROM sheet1 WHERE colA > earliestDateToGetDataFrom but this kind of query...

Oh!! I'm selecting the data to insert it into an ADO recorset and then place it into an Access table. From there it will be queried (SQL Select) to provide the data for a report. Will