MORE SQL Insert in VBA

[Pat Backowski]

After some kind help from 'mscertified' yesterday, I need some help in the
following in VBA:

Insert into Pend_Link_Table (LinkID, Route_ID) Values (LinkID, Route)

LinkID is numeric and Route is a string, with corresponding data types in
the table.

I'm lost in &'s, ', and "

Many thanks for you kind assistance,
Pat.

 

[Allen Browne]

Pat, this might help so you don't have to keep asking every time you need a
SQL string:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

 

[Pat Backowski]

Thank you Allen - I was able in 5 minutes to understand what its all about.
As you know I've been struggling with this for the last month.
Many Thanks and "Cheers"
Pat.