insert into

  1. A

    Select Query IIF Not testing column value

    Hi all, I have a query that I use to export a text file for another database. I am currently testing changes, and need the same output, but formatted into a series of "Insert Into" statements to be able to develop. So I wrote another query to produce a fully formatted text string for each of...
  2. D

    SQL Statement giving "Syntax error insert into statement"

    First, I want to make everyone aware that I'm new to VBA, SQL, AND Access. Our data guy let suddenly so I've been given the job of maintaining my organizations databases even though my background is in Educational research. :eeek: So I'm sorry if I give too much/not enough information and if my...
  3. E

    Run-Time Error '-2147217900 (80040e14)': Incorrect Syntax near 's'.

    I am trying to insert data into a SQL table from an excel table. I am able to get this code to work about 6 or 7 times but it hits a point where it hits this run time error. 'Setup Command Update Dim BTcmd As ADODB.Command Set BTcmd = New ADODB.Command Dim r As Range BTcmd.ActiveConnection =...
  4. ClimoC

    ODBC Oracle link to Access table with defined query

    Hey ho I'm trying to move part of an Oracle table-view into a new Access(2010) table. I tried linking the table with an ODBC connection from Access - but the Oracle table is both too large for Access to handle, and Access also ended up jamming the server and p*****g off the Oracle DBAs. I...
  5. H

    VB to Move Named Ranges to Access Database

    I'm writing my first "advanced" VBA code to move Named Ranges from Excel to Access. The Named Ranges are named the same as the Access Database field names. When I run my code, I receive the following error: "Object required". When I click "Debug", the debugger highlights DoCmd.RunSQL strSql...
  6. Avatar

    Excel VBA + Massive Array + SQL INSERT = HELP!

    Greetings, I have an array (dimensions: 1.5mil,14) containing data entries that i need to INSERT into an Access 2003 table. I am hoping to do this as a single SQL string... Is this possible? below is the code in a nut shell. Sub sbRun() Dim aryDataSet() Dim i As Long, _ lngTopRow As...
  7. L

    ADO INSERT INTO with Excel table

    Hi, I'm writing some code to use ADO to pull some data from access. Everything works fine but I want the data to be placed in an existing table and using CopyFromRecordset seems to wipe the table. I can use an ODBC query, change the command and refresh but I'm trying to learn more about ADO at...
  8. K

    Excel bulk data copy to SQL server using VBA / ADO

    I am fairly familiar with recordset basics and have used Excel / VBA to interface with a back-end database in the past. I have a problem where data contained in an Excel spreadsheet is taking too long to update to a SQL server due to the many rows of data (recordset.update or updatebatch is...
  9. P

    Excel to access - recordset problem

    I am trying to insert values in a range to an Access recordset. My problem is with: rst = CreateObject("ADODB.Recordset") and then later in: rst.Open "INSERT INTO " & tblName & colHead & " VALUES " & rcdDetail, cnt rst doesn't seem to be recognised at all. Help will be appreciated. Sub...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top