Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA excel to access array
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA excel to access array
Resolved · Medium Priority · Version 2003
Reply Wed 14 Jan 2009, 16:56Delegate Cameron said...
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
For upcoming training course dates see: Pricing & availability
Reply Mon 9 Feb 2009, 13:03Delegate Cameron said...
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??
|