PDA

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