Validate File before imort

[John]

I have an "import" button on a form that prompts the user to select a file to
import. The file must be an Excel file that contains the proper data. The
import 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 import:


DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "tblMonthly",
fn, True

Does the "...acSpreadsheetTypeExcel5..." ensure that it's an excel
spreadsheet?

 

[bhicks11 via AccessMonster.com]

Excel 5, being backwardly compatible, would allow older versions.

Bonnie
http://www.dataplus-svc.com

 

[John]

I am not sure I follow you bhicks11... How does this answer my question?

 

[bhicks11 via AccessMonster.com]

Oops, sorry John - I thought you were trying to limit to Excel 5.

I am not sure I follow you bhicks11... How does this answer my question?

Excel 5, being backwardly compatible, would allow older versions.

[quoted text clipped - 14 lines]

 

[John]

I found my answer from a previous question. (Thanks Doug!)

From Doug:
See my July, 2005 "Access Answers" column in Pinnacle Publication's "Smart
Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html