Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
vba excel access array

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA excel to access array

VBA excel to access array

ResolvedVersion 2003

Cameron has attended:
Access VBA course
Access VBA course
Access Advanced course
Excel VBA Intro Intermediate course

VBA excel to access array

Hi

Ok so I'm at work and someone suddenly wants a spreadsheet to behave like a database.

We have a workbook with worksheets for months individual dates as column heads, company names for rows in the cells is the number of visitors brought by that company on that date.

Is there a simple way to pull all this info to an array (I'm guessing that it would have 3 dimensions) and then write the array to a table (or 2) in access?? if you need examples etc let me know.

Cameron

RE: VBA excel to access array

This one is not a problem any more, I've produced some code which my people seem to be happy with. the code doesn't actually export it from excel but changes the data to a form which people can manipulate.

Is there a way to post code here which is not so messy as to just paste it in??

Please browse our web site to find out more about
access+training and other training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.08 secs.