Saving an Array from Excel and writing into an Access Table

[Jaryd]

Hello,

So I wanted to work on this tonight and learn, but forgot to bring my code. Anyways, I would love some help or pointed to good resources.

I have an access macro that opens excel and runs a macro to make an array. I am having trouble getting that array to stay when going back into access. I also don't know how to add the data from the array into an already existing table.

I tried declaring the array as Public in access. It works in excel, but disappears when coming back to access.

All my table and array lengths match up for the writing to table.

Any help or advice would be great. Thanks.

 

[iliace]

Without the code, it is too much of a stab in the dark to tell how to go about this.

Most likely, you will have to parse the array out of/into a Recordset object. This will enable you to write it back to Access.

You may want to take a look at these resources:

https://www.connectionstrings.com/ace-oledb-12-0/
https://msdn.microsoft.com/en-us/library/office/ff965871
https://msdn.microsoft.com/en-us/library/ms681510(v=vs.85).aspx

 

[Micron]

Are you able to place and save the array into a worksheet, or is this just in machine memory? If you have saved it, the TransferSpreadsheet function could transfer the data from Excel to Access.