Import ADO.Recordset into Access table on the fly!?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,

What's the best way to create and populate Access table
from a Recordset (code runs outside Access). Please bear
in mind:
1. The code that does that runs from a vb app that runs
unattented.
2. The Recordset will have in the excess of 100k records.
3. I have to create the table "on the fly".

Is there a smart way to do that without having to identify
the datatype of each column and generate create table SQL
statement?

Is there a straight way to match Recordset column data
type with a Access column datatype to use in a Create
Table SQL statement?

Do I loop the recordset in insert each record in the
access table? Is there a better option?

ANY advise is appreciated!

Regards,
Emil
 
To my knowledge you have to write code.
Try searching or posting in other groups for a sample (I don't have one, I
think...)

I proposed a few years ago that Access include a SaveRecordsetAsTable
method.
Haven't thought about it for years.

Had to write similar code for importing XML to A97.
Quite ugly.
 
Back
Top