Inserting MS Access data into Excel as new rows below existing data

**mptorr** · 08-16-2012, 09:56 PM

I need to import rows from an MS Access table into Excel. The VBA macro below does just that.

Please Login or Register  to view this content.

MS Access table1

Please Login or Register  to view this content.

When I run the macro once, I get in Excel

Please Login or Register  to view this content.

When I run the macro again, I get in Excel

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Do you know what I should change in order to import MS Access rows into Excel as new rows of data below existing data?

**Trebor76** · 08-17-2012, 01:07 AM

Hi mptorr,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

**mptorr** · 08-17-2012, 12:03 PM

Thanks Robert! That worked beautifully.

Now I am trying to JOIN two tables [pseudocode]

Please Login or Register  to view this content.

but just can't get the query syntax to work in the .CommandText line.

Do you have any suggestions?

**Trebor76** · 08-17-2012, 09:04 PM

Do you have any suggestions

You should start a new thread for each new (different) question and mark this one as Solved.

Thats said, one thing you could try would be to create a query on the database and once you have it working as it should, check it's SQL and try and put that into your code.

Regards,

Robert