Need help related to export data from excel to access using ADO

A

amols.jadhav

New Member
Joined
Aug 22, 2012
Messages
6
Hi Experts, Please help me If I want to transfer data from excel to access using vba, where 1) I have excel sheet with Header at top row and some data below it. 2) Once I run my macro access table will get created and My excel header row will be my access field names and data will be accordingly. It will be very great if someone provide me raw code. Regards, Amol J
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

C
  • Question
What libraries can be used to access SQL Server databases using Excel/VBA on a Mac?
Replies
0
Views
235
chuckbo
C
L
  • Solved
Querying access db from excel - 32 bit to 64 bit conversion
Replies
2
Views
107
JEC
JEC
C
  • Question
Porting an Excel application to Access
Replies
6
Views
276
chazrab
C
M
  • Question
Access data from a closed workbook
Replies
6
Views
193
Micron
M
M
  • Solved
VBA Help - Duplicate & Unwanted Data Removal
Replies
6
Views
205
MoonDancer
M

Forum statistics

Threads
1,216,100
Messages
6,128,825
Members
449,470
Latest member
Subhash Chand

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top