ssql

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

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

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

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

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

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

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

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

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