Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. krankyboy

    using Excel workbook as a datasource for ado connection object execute

    Hi, I want to import data from an excel workbook using a connection object based on my Access DB. What is the syntax? I do currently with a text file no problem. my code is something like: connectionObject.Execute "Insert into mytable (fieldnames from excel sheet Datasource ????? HDR =yes...
  2. krankyboy

    viewing a resultset in access and ado command

    Hi, I have an application that allows a user to choose a query from a dropdown and select certain date parameters in order to generate a resultset which will need to be copied and pasted to Excel. I can do this easily with a DAO querydef but how do I do this with ADO and a command object. I...
  3. krankyboy

    importing data from an excel workbook created from a webserver

    Hi, I need to import data from a workbook that is created after navigating to an ASP page. I'm using the getobject function and can read the worksheet but this is while I'm stepping through the code. The workbook becomes the active window and I have to move back to my VBA code in Access to...
  4. krankyboy

    Report based on parameter query

    Hi, I have a query that I want to run a report off of. I've defined two parameters of date/time type, [stDate] and [enDate]. These two parameters are then used in 6 columns of the query. Can I just use the Where clause in the Docmd object such as [stDate] = some value in my textbox...

Part and Inventory Search

Back
Top