Export a recordset to Access

[PotatoTang]

Hi,

Is there any quick method to export a recordset (in VB) as a MS Access table?

I just use a looping to export record one by one to MS Access table. I would like to know whether there is another method which can export all records at once.

Thanks.

 

[petermeachem]

Look up INSERT sql statements. It is often better to drop the table if it exists, create it with the right fields and then insert the records, otherwise the field types may not be what you expect.

http://www.therockalltimes.co.uk/