I'm trying to pull data from a SQL table and populate a pre-existing Access97 table (template) with the same fields as the SQL table using a stored procedure.
Unfortunately, it's not working.... Here's the statement in the procedure:
INSERT INTO " + @DbName + "...tbl_Master (n_number, serial_number, mfr_mdl_code) SELECT n_number, serial_number, mfr_mdl_code FROM tbl_AC_Master WHERE state = '" + @State + "'
Where @DbName is the database name and @State is the variable state (which are both being passed to the procedure)....
Any ideas why the procedure won't populate the Access97 db? If nothing seems obvious with this SQL statement (I can't see anything), anything that can be suggested to look for would be greatly appreciated!