Transform VB string array to table

C

CyberDwarf

Anyone out there know of a simple way to pull data from a 3 x 10 string
array in VBA into a SQL table?

Trying to avoid looping thru' the array!!!

TIA

Steve
 
D

dbahooker

i dont know what you mean by 3x10

but i would start with looping throgh it and pushing it into a table
 
R

Robert Morley

Going the other way around with ADO is easy, but I don't think there's an
easy way to to from an array to a table.


Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forcing xl2K7 Column Count back to xl2K3 size 3
concatenate entries from a column into a cell by logical AND withanother column 2
Finding the maximum in an array of strings (Excel VBA) 6
VLOOKUP duplicate values in table the table array? Help me solve 1
Array - retrieve certain amount of recods for query 0
Need help finding a substring in a array of strings. 1
Long strings 2
MultiDimensional Array Syntax 4

Top