Excel to Access

mrafiq44

New Member
Joined
Oct 14, 2015
Messages
28
Can journal detail from 10 divisions in excel exceeding 100,000 lines each be exported into access, so that all data can be viewed in one database at one time instead of opening 10 different worksheets?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sure. Access has an overall database size limitation, not any record number limitation.

Assuming the layout, structure of all these Excel files are the same, there are a few ways you could go about this:
- import all 10 files into a single table in Access
- link all 10 files to separate Access tables, then use an Append Query to sew all of these together in a single query (see: this would only add up the 1st item and then the item from the vlookup. i was needing to add up from the 1st item THRU the item in the vlookup.)

The advantage to the second option is it doesn't require you to import everything. So, if your data files are constantly changing, and you need to do this multiple times, the second option may work better. All you need to do there is replace the Excel file each time (with file of the exact same name in the exact same place).
 
Upvote 0

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

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