#1

Moving data from Excel to Access

in Excel discussion Fri Dec 29, 2017 3:37 pm
by JoeClark • 62 Posts

Hello All,

I have created an "Archive" sheet which will hold 60 rows per day. The sheet is likely to get very big very quickly so I'm considering using Access DB as a way of storing the data. Is there a neat automated way of moving the archive data into an Access DB e.g. VBA?

Please help.
Thanks!

I didn't find the right solution from the Internet.

References:
https://www.mrexcel.com/forum/general-ex...cel-access.html


product video content

Scroll up


Visitors
0 Members and 2 Guests are online.

We welcome our newest member: Karry Amanda
Board Statistics
The forum has 2268 topics and 7765 posts.