Hello,
I have a problem with importing data from ms access to excel with VBA. I use "ADO Connection" to connect excel with acces. When I use "xlSheet.Range("A5").CopyFromRecordset rs" to import data from access db, it's works fine. But I want to skip some column in excel sheet. How can I do it? sorry im new in vba ..
my db table
<tbody>
</tbody>
my excel sheet
<tbody>
</tbody>
I have a problem with importing data from ms access to excel with VBA. I use "ADO Connection" to connect excel with acces. When I use "xlSheet.Range("A5").CopyFromRecordset rs" to import data from access db, it's works fine. But I want to skip some column in excel sheet. How can I do it? sorry im new in vba ..
my db table
id | name | date | description |
<tbody>
</tbody>
my excel sheet
A | B | C | D | E |
id here | name here | date here | skip column | description here |
.. | .. | .. | .. | .. |
<tbody>
</tbody>