Import spreadsheet using command button

[ambs24]

I'm looking for a way to set up a command button that will perform the same operation as the import spreadsheet wizard. The wizard is simple enough, but the operation will be performed daily and the parameters will be identical each time, so it seems like a command button would save my users a lot of time. Does anyone know the best way to do this?

Thank you!

 

[SgtJarrow]

The proper code for this is....

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "NameofTableForSpreadsheettoBeSavedTo", "PathandNameOfFiletoImport"

add ,True to the end if the file has field names you wish to preserve. "As far as the laws of mathematics refer to reality, they are not certain; as far as they are certain, they do not refer to reality."--Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer