Access XP - best way to pull in Excel worksheet in automatically

[mastro78]

I currently have a bunch of Excel spreadsheets (more to come) that reside in the same directory as my database. However, I want to run a function on the OnOpen event in my switchboard to pull the data into the specified table. Now, I'm wondering what is the easiest way to go about this? Please advise, thank you!

 

[PHV]

Have a look at the CurrentProject.Path property, Dir function and DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886