Recent content by starter

I deleted the records from mssql. I removed "On error resume next". When I select the file for import, I get this error: Run-time error '3061': Too few parameters. Expected 1. Issue appears with: 'attempt to append import to MSSQL table Dim lngRecordsAffected As Long DoCmd.SetWarnings False...

Thanks. No records are appended to dbo_tCCTransactions when I try this.

Hello, please see post #6. It just gives the difference between the records in the previous import file and the current import file.

I'm not sure where the import and error filtering step is happening. Importing the file appends all the records to the the local tCCTransactions table, even ones that are duplicates. I just tested by creating a file with 244 records. I added two records in there that are duplicates from a...

Yes exactly. The previous import had 133 records. I did another import to confirm. The import had 157 records. The message was: '157 records found 54 records were imported' The old transactions are still there in the SQL table (dbo_tCCTransactions) and available for the users, they're not...

The query is: INSERT INTO dbo_tCCTransactions ( Name, [Short Name], [Account Number], [Managing Account Number], [Managing Account Name], [Managing Account Name Line 2], [Social Security Number], [Optional 1], [Password], [Current Default Accounting Code], [Lost/Stolen Account], [Replacement...

That doesn't seem to do it. I tested importing a file with 103 records. '103 records found -30 records were imported' All 103 records were successfully imported.

Hello. Thank you for the quick response. The number of transactions is always different.

We have an app where users can import transactions into from excel. When users import transactions, they get a window with the results: "X records found X records were imported" The X records found is working properly. The X records were imported is always 0. Although transactions are being...