>I was wondering if this is possible:
>I make a SELECT statement from an Oracle database and I want to save this resultset into my local Access table.
>But when I save, I want to create a new table.
>This would look like doing a SELECT INTO...
>P.S.: I don't want to link table in Access, and I'm doing this from VB.
>
>Thanks
>
>Patrice Merineau

Hi Patrice,

What about a combination of these two examples?

http://msdn.microsoft.com/library/books/dnjet/c3_body_1.htm
http://support.microsoft.com/support/kb/articles/Q209/0/37.ASP

The first to create the Access database file, the second to add a table to it, all from code you should be able to run in VB.