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

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

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,119
Messages
5,546,045
Members
410,722
Latest member
Jojo3008
Top