I have an "im****t" button on a form that prompts the user to select a file
to
im****t. The file must be an Excel file that contains the proper data. The
im****t works great, but now I am trying to "idiot proof" the code. How is
this best done? I need to check the type of file they selected (IE: type
=
XLS) and some key information in the second record of the sheet. Here's
the
code I am using to im****t:
DoCmd.TransferSpreadsheet acIm****t, acSpreadsheetTypeExcel5, "tblMonthly",
fn, True
Does the "...acSpreadsheetTypeExcel5..." ensure that it's an excel
spreadsheet?
--
Thanks - John
