ssql

  1. B

    SQL Insert Statement > Start Insert Records from Row(3) and onwards

    Hi Community, I need some help running a SQL statement to insert rows starting at Row #3 . The statement works and will insert records, but I can't get it to start inserting at Row #3 which is messing up the data that's being put into the Access Database. Any guidance? Public Sub ShiftSwap()...
  2. T

    error retreving data from access to excel

    not sure why I am getting this error: no value given for one or more required parameters. Here is my code - can anyone point me in the right direction? Sub GetRecords() Dim cnn As ADODB.Connection Dim RST As ADODB.Recordset Dim WSOrig As Worksheet Dim WSTemp As Worksheet Dim sSQL As String...
  3. M

    Audit Trail code not working

    Hello, I am trying to use the following code for audit in an access database,but nothing is being added to the tables. Am I missing something? Option Compare Database Option Explicit Private Const conMod As String = "ajbAudit" Private Declare Function apiGetUserName Lib "advapi32.dll"Alias _...
  4. C

    VBA to insert data from Excel to an Access Database limited to 255 characters

    Hi all, I have some code that inserts lines of data that a user enters into Excel into an Access database. For some reason I am unable to upload more than 255 characters in a cell to Access. I have the Access column set to "Memo" and if I manually paste data >255 characters directly into the...
  5. K

    Adodb connection error with multiple users

    I designed a tool using vba with few buttons (Get claim, Save, Hold and Clear). Work allocation is at separate file within same shared drive from which claim will come to handlers one by one. (Process first then ll be able to get next one) Managing 100 people on this seems difficult, when...
  6. C

    [VBA] Inserting Data from Excel to Access Database

    Hi all, I'm having issues with some code that takes lines of data entered by the user and inserts them into an Access database. I swear this code was running correctly a couple days ago and has started misbehaving today :confused:. I've double checked that the excel headers match the...
  7. skorpionkz

    [VBA] Creating record in Access DB from Excel VBA

    Hi guys, I have code that loops through the records (class objects in dictionary) and adding them to the Access database. My understanding is that you can't add 2 dimensional array to the Access Table and need to add them 1 by 1. Previously my table was in .csv file and it took about 3-4...
  8. B

    Insert Excel data table into Oracle table using ADO - keeps crashing Excel

    I am trying to upload a data table (approx 20 columns and 3k rows) directly into an Oracle database using the code below (username & password removed for security), but each time I try to run it, Excel is crashing out when it gets to the .Execute (ssql) line. Public Sub TransfertoOracle() Dim...
  9. B

    Syntax error INSERT INTO keeps occurring.

    Hi everyone, I'm currently working on a project where I want data taken from an excel table imported into an access database. The excel table cannot be linked to the access. This is the code I am currently using: Sub AccImport() Set cn = CreateObject("ADODB.Connection") dbpath =...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top