Search results for query: *

Correction Previous: "INTO TABLE " & SQLnew Actual: "INTO TABLE " & HFFilname No errors. No file created in location.

Here's what the code is exactly: " Sub CreateHFfile() Dim Conn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim sql As String Dim shock As Double Dim path As String Dim basefile As String Dim shockfile As String Dim HFfile As String Dim BaseFileName As String Dim ShockFileName As...

Better example of what's not working: SET EXCLUSIVE ON; ALTER TABLE table3 ADD COLUMN hf n(6) NULL; UPDATE table3; SET hf=(SELECT table2.val FROM table2 WHERE id = table2.id) PACK;

Thanks for the comments. I need to create an Excel tool that the user can input the name of free tables. The tool takes values from both tables in order to create a new field or values. The new field needs to be paired up with the correct record and the new file needs to be in the same...

I have two tables (free tables) that are exactly the same except for 1 column. I need to calculate this difference and append the column of differences to one of the original files. I'm doing this from Excel VBA. Here's what I'm trying to do: SELECT table1.id, (table1.val - table2.val) AS...