Popluating data from ms access

  • Thread starter Thread starter phong.lee
  • Start date Start date
P

phong.lee

Hello all,

I was wondering if anyone can give me a hand. I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in
excel. Can someone guide me in the right direction in vba ? thanks
in advance.
 
Uzytkownik said:
Hello all,

I was wondering if anyone can give me a hand. I just created a button
that has code within it to open a new work book and rename some tabs.
The next thing i need to do is some how be able to popluated the excel
sheets with data from MS access queries into the correct tabs in
excel. Can someone guide me in the right direction in vba ? thanks
in advance.
Click to expand...

F1(CopyFromRecordset)
 

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

Excel form to update data from MS Access data table based on criteriain excel sheet 2
Help: Creating dynamic sql queries in excel 1
Run MS Excel Macro From MS Access 2
Reset All Command Buttons on an Excel UserForm 20
Access #Error & Excel Pivot 0
How do i write data from Excel to a table in Access (2007)? 4
Access Import & Link section grayed out MS Access 2010 1
>_< Excel 2010 Assistance Please! 0

Back
Top