dao

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...