Importing into access from excel

L

LAS

Board Regular
Joined
Oct 29, 2002
Messages
215
I perform many creditors reconciliations in Excel and they are all automated BUT the one of the creditors has become too big for excel.

I would like to keep the excel interface but do the following.

Via excel, import the data (text and .xls files) into a Access database, run some queries on the data and return certain results to Excel.

Running the queries on the Access database and returning the results to excel are not a problem.

THE QUESTION IS, how do I import the data via Excel VBA into a ACCESS data base.

Thanks for your help.
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
You don't necessarily need to import the data from Excel. You can leave the data in Excel and link the data to Access tables. To do this, go in Access into Tables, right click and select "Link".

The advantage to this is as your data changes in Excel, it will also change in Access.

You can perform queries on linked tables just the same as you would for regular Access tables.
 
Upvote 0
I want to automate the import / link process in Access from Excel.

I maybe should automate it from Access itself, but I am more familiar with EXCEL's VBA.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Trouble running an access query in excel vba
Replies
2
Views
107
Legal Tender
L
A
  • Question Question
Update a field in Access from Excel
Replies
4
Views
166
AlexanderBB
A
L
  • Solved
Querying access db from excel - 32 bit to 64 bit conversion
Replies
2
Views
703
JEC
JEC
P
  • Question Question
Mail Merge - Address Labels, from Excel, selecting specific criteria, please?
Replies
1
Views
232
FormR
FormR
P
  • Locked
  • Question Question
Mail Merge - Using Excel & Word, how to select specific criteria ?
Replies
1
Views
183
Fluff
Fluff

Forum statistics

Threads
1,223,261
Messages
6,171,076
Members
452,377
Latest member
bradfordsam

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