VB in Access

[Richard]

I have a VB Module that creates an array of numbers and I would like to know
how to dump them into (populate) a table in Access. And also create a new
table from the VB Module, hopefully in the background. Any one who has any
examples of code I would appreciate suggestions.

 

[Perry]

To add records:
Try an AppendQuery in MS Access, snatch the SQL code, adapt the code to fit
yr needs and run this SQL command in VB

To create a table
Try a MakeTable query in MS Access, snatch the SQL code, adapt ...etc

 

[TC]

To create the table, he needs the CREATE TABLE sql statement. To add
the records, he needs the INSERT sql statement. OP, you need to read-up
on those two sql statements, and find out how to run an sql statement
from within VB.

HTH,
TC