Pull data from table..

[VBABEGINER]

Hi Experts and all,

I have new and very 1st query on access db.

Table name "Data", contains 4th and 5th column email id's. I want to fetch that in variable. Can any one provide me select query, how to write that..

Many Thanks..

 

[VBABEGINER]

Hi Joe, i appreciate your time to reply my queries.. Thank You for that..

Actually it is already created application in 2006 some where.. and now one of my finance team looking for this change request. and hence asking.. and hence im trying.. I never write this type of query to pull data from access tbl.

I generally ask question's on vba, infact whatever i learn vba that is b'coz of MrExcel. and hence i was / will always pretty confident that i will have solution here..

 

[Joe4]

Maybe take a look here: https://docs.microsoft.com/en-us/do...ide/concepts/linq/walkthrough-writing-queries

If you go a Google search on "Write SQL Query in Visual Basic 6.0", you will find other articles/videos that may be helpful.

 

[VBABEGINER]

Thank You for reply.. always looking for your assistance..

 

[Joe4]

You are welcome.