View Full Version : Advice: Excel to Access DB
bkudulis
09-27-2004, 08:11 PM
I have a form that in Excel that gets filled out. At the bottom of this form there are some rows that calculate and consolidate the data. I would like to take these rows of data and append them into an Access database. The workbook that contains the forms gets changed every week so I cannot link the DB to a worksheets thaqt gathers all of the information. Is there a way to append these records to a DB through a macro in Excel?
Aaron Blood
09-29-2004, 06:35 AM
ExcelTip has a decent ADO example.
http://www.exceltip.com/show_tip/Import_and_Export_in_VBA/Export_data_from_Excel_to_Access_(ADO)_using_VBA_in_Microsoft_Excel/425.html
XL-Dennis
10-02-2004, 05:07 AM
Hi,
I always prefer to read data into variant-arrays then working directly with ranges which the following example shows:
http://www.excelkb.com/article.aspx?id=10090
Kind regards,
Dennis
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.