Hi,
I have code written which imports excel data to a access table and I want to validate it to prevent importing the duplicates. How can I do that?
Thanks.
My code is below,
Public Function FolderSelection() As String
Dim objFD As Object
Dim strOut As String
strOut =...
)Thank you Colin it corrected by,
"WHERE Main.[Report_Date]='" & Me.rd.Value & "'".
But what you mean by no join between tables?? :confused: I am sorry I am new to access VBA.
Hi I design SQL statement in access and now i want it run through button using VBA. but I got end of statement. I don't have idea to fix it.
Dim sqlImport As String
sqlImport = ""
sqlImport = sqlImport & "INSERT INTO Main ( Report_Date, LEA, CRM_ORDER, SO_ID, SO_STATUS...
Hi! How can I import data from excel to existing table in access using button?
User is selecting the excel file from windows explorer and I want to program to enter only some columns to access table. And I am inserting date from form too.