Help with Access query from Excel

  • Thread starter Thread starter jayklmno
  • Start date Start date
J

jayklmno

I am using Access to hold data in tables and use SQL to query from Excel. So
far I have been successful. As I learn more about Access, I am now using a
query to pull together data from multiple tables and using SQL to pull that
data into Excel. I am having a problem with a select query. The data is
correct when I look at the query, but after I pull it into Excel, it's not
the same. Is there anything I should know about pulling data from a select
query as opposed to a table? If I put the same data into a table, it pulls in
fine. What is going on?
 
The same code works fine if it's from a table, but when it's from a query, it
doesn't update correctly.
 
It would help if youcould post your SQL and also your code.
What's different about your results in XL vs Access ?

Tim
 
Back
Top