Import Query in Access to Excel

Hi

Ran your code only changing the name to match a query I have, and it worked correctly.

Are you sure you are using the correct query name?

rylo

Hi Rylo,

Thanks for your reply. I'm sure that I relace the correct name of query, however it does not work.

Nam

Hi Rylo,

I have tested and found out that

If the query is

SELECT INVREGISTER.Reference, INVREGISTER.InvNo, INVREGISTER.OurRef, INVREGISTER.Creditor
FROM INVREGISTER
WHERE (((INVREGISTER.Creditor) Like "SCHLUM*"));

The macro does not work

If the query is

SELECT INVREGISTER.Reference, INVREGISTER.InvNo, INVREGISTER.OurRef, INVREGISTER.Creditor
FROM INVREGISTER
WHERE (((INVREGISTER.Creditor)="SCHLUMBERGER SEACO, Inc."));

The macro works perfectly

I may think that there is a difference of SQL in Excel and Access

Do you have any ideas?

Nam

Nam

I see what you mean.

Try putting the sql directly into the macro rather than pulling from an existing query. Change your rs.open to something like

Please Login or Register  to view this content.

rylo