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
Printable View
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
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
Hi Jamie
Did you find a way to do it ? How did you go about it ..I have the same problem .
Thanks ..