Creating an Access table in VB

[harrisw]

How can I create an access table using purely vb6.

I want the user to be able to specify how many columns the table will be in the vb app

I also need to be able to sort an existing table in the access database by a certain column.

2 questions in one.

Any ideas?

 

[harrisw]

AM using ADO but can't find a command to create table. I've also tried MS Knowledge base