troubleshooting Question

Using a VBA text variable in SQL

Avatar of Rick Rudolph
Rick RudolphFlag for United States of America asked on
Microsoft AccessMicrosoft Development
7 Comments1 Solution862 ViewsLast Modified:
I am trying to append records from one table to another in vba using an SQL string. The only difference between the two tables is that the target table has one additional field from source table. This is the SQL generated from the Query Expression Builder:

INSERT INTO Bloomin_Transmission_History_File
SELECT Bloomin_XFER_FILE.*
FROM Bloomin_XFER_FILE;


This works fine either run as a query or in VBA.

My question is that "Bloomin_Transmission_History_File has one additional Text Field that I want to populate with the value of a string variable named:  ExpFName. the Field Name I want to update with this variable is:  [Transmission File Name]
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros