dao

  1. J

    VBA/DAO: Inserting MANY rows of data from a range into a SQL Server table

    I know -- ADO is much better for many reasons, but for various political reasons I have to use DAO. Anyway, I've written VBA/DAO code which inserts from a range to a SQL Server table one row at a time. It's cumbersome, because I have to slap together an INSERT INTO table (columns) VALUES...
  2. A

    VB Access DAO converting to SQLDB

    Hello guys, My company has a huge VB, wich contains of 15000 lines. Now this is connected to a access db, but because it needs to connect to a Maximo environment, it need to change to a sql database. What are the easy ways or hard ways for me to change this. Or is there even an option to...
  3. V

    DAO FindFirst Recordset - Excel Data Base

    Hey, Guys Please, Can you help with an DAO issue? I need to use an Excel data base instead of an Access data base. I am having a problem with this command: Recordset.FindFirst I guess that the syntax is not ok. The problem: rs.FindFirst "[FirstName] = " & Chr(34) & Resp & Chr(34) Here is the...
  4. F

    Updating Access with Excel Data - Help!

    Hello Mr. Excel Community! I wrote a macro for consolidating my company's budget data into Access Databases to make things easier on our IT department. The code works, however it's extremely slow and I know there is a much faster way to do this. Right now my code loops through 100+ csv...
  5. N

    Neew help with a query in a database using DAO 3.6

    Hi :), I have the following code : to test the entry in a database : Sub test() Dim x As Integer x = Add_NewBatch_DB(125, "12/05/2011", "20/06/2015", "20/06/2015") End Sub Private Function Add_NewBatch_DB(CptMach As Long, TmpSupp As Date, TmpNP As Date, CurrDte As Date) As Integer...
  6. ClimoC

    Working Passthrough in Access, doesn't work in VB6?

    Hey hey Pretty sure I've got all the right references etc, but the following works in Access VBA: Sub TestDump() Dim db as Database Dim LPT as QueryDef, tblDef as TableDef Dim DStmp as string, connstr as String DStmp = Cstr(Format(Now(), "yyyymmdd")) Set db =...
  7. nuked

    Updating records in linked Sharepoint table

    Bit of a long-shot on here, granted, but I wonder whether anyone could give me some generic advice. I have a sharepoint list with about 50k records (I know this has busted the recommended capacity by a considerable degree!), and I have linked this list in MS Access 2003. Now, this list has...
  8. J

    How to do VBA -> LDAP -> OIM -> Oracle?

    I have several VBA applications that interface with Oracle databases. Up to now we've been using ODBC, DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the password. The oracle clients and...
  9. J

    How to do VBA -> LDPA -> OIM -> Oracle?

    I have several Access/VBA applications that interface with Oracle databases. Up to now we've been using ODBC (via Access links), DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the password. The...
  10. J

    How to do VBA -> LDAP -> OIM -> Oracle?

    I have several spreadsheet/VBA applications that interface with Oracle databases. Up to now we've been using ODBC (via Excel queries), DAO (via the DAO360.dll library) and ADO (MSADOnn.tlb) to get to them using a connection string that names the Oracle database server, the userID and the...
  11. A

    ADO Connection question

    Hi, I have a connection between Excel and Access. From Excel, I query Access and use the Recordset method to put the data into a sheet. Can I use this to somehow Update or Edit an actual query that's in Access ? Please advise yes or no. I think its No ! Thanks, ABB
  12. N

    Vba ado

    I'm having a problem creating a VBA ADO to call a select statement from a table and display it in the immediate window. (I really have no idea where to start either) http://www.blackbootmedia.com/School/FinalProject.accdb What I need to do is "Create a VBA function to produce a report in the...
  13. S

    DAO OpenDatabase failure

    Hi, Does anyone know how to force OpenDatabase to open as read only. I've tried setting the ReadOnly argument to true to no avail. The main curveball is that the security on the file only allows users "Read & Execute" priviledges, but even trying to use the ReadOnly argument results in an...
  14. B

    Unrecognized DB Format Error 3343

    Hello, Excel & Access 2007. I am trying to import a query from Access into Excel and I keep getting this error "Error 3343 Unrecognized Database format". Can anyone help me? Here is my code: Sub Import_Agent_Info_DAO() Dim strDB As DAO.Database Dim strQD As DAO.QueryDef Dim strSet As...
  15. B

    Trouble Querying Access From Excel - VBA

    Hello, I keep getting the error "Unrecognized database format" when running this code and I can't figure out why. Any ideas? Any ideas on how to fix it? Sub ImportAgentTablesDAO() Dim AgentConn As DAO.Database Dim AgentRec As DAO.Recordset Dim AgentQry As DAO.QueryDef Dim DataSource As...
  16. D

    Importing Large CSV File into Excel Using VBA

    The below code works, but for whatever reason it doesn't seem to recognize the commas which need to be taken into account since the data is comma delimited: Sub Import_Large_Textfiles_DAO() 'Note: A reference must be set to Microsoft DAO 3.5 or 3.51 'Note: A reference must be set to Microsoft...
  17. T

    DAO IgnoreNulls and copy value down a table

    I've got some data that I'm trying to dump into a database from excel. Everything is fine except I'm stuck on trying to get the average of some values into the database. Because sometimes I've got 2,3,4, or 5 values that I'm taking the average of and getting some statistical data on, I have...
  18. C

    Named Range Not In DAO Tabledefs Collection

    Hi folks, I'm creating a DAO database in an excel spreadsheet to use some SQL for data manipulation. I've got some code that creates a named ranges for different sets of data I then create a DB object and use SQL to manipulate the data in the named range. I use this method several times in my...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top