Search results
-
A
Solved INSERT INTO works only on local table
Hi guys! I am facing a really weird problem. I am using this code: .RunSQL "INSERT INTO TBL_ALL_EMPL_DATA (" & tableFields & ") " & _ "SELECT " & inputReportFields & " " & _ "FROM [Excel 12.0 Xml;HDR=YES;DATABASE=" & inputReportPath & "].[WorksheetName$]" in order to import some... -
A
Refer to another row in a table
Hello all, My problem is as simple as I can't figure it out :) Basically, I have a table with 6 columns (Field1, Field2...) and a primary key called ID (1,2,3,....). In the first column (Field1) I want to retrieve the value from the 6th one (Field6) but from the above row. Something like...