VBA excel to access array

Resolved · Medium Priority · Version 2003

Wed 14 Jan 2009, 16:56 Delegate 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

Mon 9 Feb 2009, 13:03 Delegate 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??

Access tip:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

VBA excel to access array

VBA excel to access array

RE: VBA excel to access array

Access articles

Access tip:

Insert The Current Time