Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Update Access Table Using Range from XL Workbook
Name:
Barry Pettis
Email (spam proof):
Email the originator of this post
Date:
Friday, January 07, 2005
Hits:
64
Discussion (Terms and Conditions):
I'm just learning how to use ADO / Access. I'm trying to integrate all the XL work that I've done with databases. The following is currently a problem that I haven't been able to solve. I have an Access data base in a particular workbook I have created the new table contents based on other data. Now the data can consist of 65000 rows so updating the database 1 row/record at a time is taking too long. Now I've been given assistance on how to perform and ADO connection on the workbook in order to query the table to get a recordset of the data. But how do I use that record set to update the database table? I've been getting some good help at the OzGrid, but I'm trying to cast a wider net. http://ozgrid.com/forum/showthread.php?t=28053 Thanks in advance for any help Regards

Sponsored by the best FTP application on the internet: