How can I update an access table using an excel file? [Archive]

Click to See Complete Forum and Search --> : How can I update an access table using an excel file?

Jamie Jerome

August 24th, 2001, 10:22 AM

Could anyone please help me with the VB code for importing an excel file into access and/or updating an existing access table using an excel file that is saved in a fixed location i.e. (c:\temp\students.xls

Jamie

makai

August 27th, 2001, 01:12 AM

you can connect to an Excel file just like Access with a Data Control - click on the connect property to see your Excel connection options

I would suggest using another control for your Access DB then loop through rows of Excel with .MoveNext and then - use .Addnew, field assignments, and .Update in the Access DB

Beginner2002

July 30th, 2002, 11:14 PM

Hi Jamie
Did you find a way to do it ? How did you go about it ..I have the same problem .
Thanks ..