Transfer data from XL into Access: best practice
 

I am using VBA in Office 2003 on Windows XP.

I'm working with some legacy code that is using ODBC (ADO) to transfer ~8000
records by ~6 fields from an Excel sheet into an Access table. This procedure
takes ~10 minutes. I want to improve its efficiency.

I know there are several methods for programmatically doing this, but what
is the fastest (ODBC or JET or what)?

1. Is there still (in 2003) no equivalent to "CopyFromRecordset" into an
Access table or must I still loop thru each field to move the data using this
type of technology?

2. Is there some other alternative that is faster, such as a programmatic
copy/paste that is more expedient?

If there is an alternative to the standard loop thru, could someone please
post example code? Thanks for your input.

Transfer data from XL into Access: best practice
 

Why not automate Access and use the import feature.

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I am using VBA in Office 2003 on Windows XP.

I'm working with some legacy code that is using ODBC (ADO) to transfer
~8000
records by ~6 fields from an Excel sheet into an Access table. This
procedure
takes ~10 minutes. I want to improve its efficiency.

I know there are several methods for programmatically doing this, but what
is the fastest (ODBC or JET or what)?

1. Is there still (in 2003) no equivalent to "CopyFromRecordset" into an
Access table or must I still loop thru each field to move the data using
this
type of technology?

2. Is there some other alternative that is faster, such as a programmatic
copy/paste that is more expedient?

If there is an alternative to the standard loop thru, could someone please
post example code? Thanks for your input.

Transfer data from XL into Access: best practice
 

Okay, I like the sound of that. But, I'm not familiar with it. Do you have
any example code Tom?

"Tom Ogilvy" wrote:

Why not automate Access and use the import feature.

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I am using VBA in Office 2003 on Windows XP.

I'm working with some legacy code that is using ODBC (ADO) to transfer
~8000
records by ~6 fields from an Excel sheet into an Access table. This
procedure
takes ~10 minutes. I want to improve its efficiency.

I know there are several methods for programmatically doing this, but what
is the fastest (ODBC or JET or what)?

1. Is there still (in 2003) no equivalent to "CopyFromRecordset" into an
Access table or must I still loop thru each field to move the data using
this
type of technology?

2. Is there some other alternative that is faster, such as a programmatic
copy/paste that is more expedient?

If there is an alternative to the standard loop thru, could someone please
post example code? Thanks for your input.