Vba to sql string converter

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,188
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi

Often i am creating some SQL string in access and then i use this in my vba code...

I have found this link that helps me convert my sql string to vba


Is there any links or functions anyone cam help me with which takes the vba string and puts it back to and SQL statement as if i need to change the SQL and i need to test in access - Im having to copy the vba sql string and then remove all the speech marks, & _etc to allow me to be able to run in access

Any help to quickly allow me to switch the codes would be really useful

thank u
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

mahmed1

Well-known Member
Joined
Mar 28, 2009
Messages
2,188
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Thank you - will save me loads of time

thank you
 

Watch MrExcel Video

Forum statistics

Threads
1,114,610
Messages
5,548,983
Members
410,887
Latest member
sjohn627
Top