D
ddobier
I'm trying to determine what's the fastest method for populating a single
table in Access from a select statement executed against a sql database. I
currently connect via ado to the mssql datasource and also make a connection
to my access db via ado. I then submit my sql statement (which is fairly
complex...ie. many tables and fields) and populate a recordset with it. I
then iterate thru this record set and dynamically create INSERT statements to
be run against my Access DB table. While this works I'm wondering if there's
a better way. I know with sql a SELECT INTO statement is much faster. Is
there a way to do this btw two ado connections? The table in mssql and my
access db are identical in field names and lengths and field position.
thanks.
Darren
table in Access from a select statement executed against a sql database. I
currently connect via ado to the mssql datasource and also make a connection
to my access db via ado. I then submit my sql statement (which is fairly
complex...ie. many tables and fields) and populate a recordset with it. I
then iterate thru this record set and dynamically create INSERT statements to
be run against my Access DB table. While this works I'm wondering if there's
a better way. I know with sql a SELECT INTO statement is much faster. Is
there a way to do this btw two ado connections? The table in mssql and my
access db are identical in field names and lengths and field position.
thanks.
Darren