How to Create an Excel File Using Visual Basic 6.0. ... 'Be sure to change the "NameOfPrimaryKeyField" value to the key field or index field in your dataset or table DataArray(r, 2) = Rnd ...

I'm connected to and manipulating a Access Database using a VB frontend. But I'd like to add a simple table with 2 fields and populate it and I'm not sure how to go about doing this, google ...