Difference between Microsoft Query (Excel) and Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a website that discribes the syntax differences between the two? I
just spent 2 hours figuring out that the Excel Query uses % in place of * in
"Like" statements...
 
Access uses a form of SQL. You should Google up SQL websites and learn it.
 
J@Y said:
Is there a website that discribes the syntax differences between the two? I
just spent 2 hours figuring out that the Excel Query uses % in place of * in
"Like" statements...
Click to expand...

That's new. It didn't use to.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Error Exporting Access Query Results to Excel 1
Counting multiple memberships 1
Access query to pivot table in Excel 1
DateDiff 4
Changing query criteria through VBA 9
Comparing Memo fields 0
Syntax Error in Query Expression 2

Back
Top