By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,949 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,949 IT Pros & Developers. It's quick & easy.

Array in Visual Basic to Table in Database?

P: 1
Hi! I am brand new here.

I am extracting data from a database table in access and then populating an array in visual basic (VBA in access currently). I would like to reformat this array and put the data into a new table in Access. Right now I am writing the output to a text file which I was thinking I could import back into access as a new table, but this seems redundant. I was wondering if anyone might be able to help me out with this. I am a VB newbie but am trying to learn fast; however, writing to a new table in access from VB is eluding me.

Thanks in advance!
Sep 4 '07 #1
Share this Question
Share on Google+
3 Replies


P: 18
I have a similiar problem I have an multidimentional array that I would like to enter the data into a new Table in Access. Did you figure this out yet? I also find the text file to be redundant, but Im not sure how to do this too.
Sep 14 '07 #2

Expert 5K+
P: 8,434
Using an ADO recordset, you can just AddNew each array entry to the table as a new record. Or you can set up an SQL INSERT statement to do it, and run this against the Connection object, which will save you the bother of opening a recordset.
Sep 15 '07 #3

P: 18
Using an ADO recordset, you can just AddNew each array entry to the table as a new record. Or you can set up an SQL INSERT statement to do it, and run this against the Connection object, which will save you the bother of opening a recordset.
I will play around with an SQL insert.

Thank you.
Sep 19 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.