by =?Utf-8?B?Sm9obg==?= <John@[EMAIL PROTECTED]
>
Aug 2, 2008 at 12:23 PM
I am not sure I follow you bhicks11... How does this answer my question?
--
Thanks - John
"bhicks11 via AccessMonster.com" wrote:
> Excel 5, being backwardly compatible, would allow older versions.
>
> Bonnie
> http://www.dataplus-svc.com
>
>
> John wrote:
> >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?
> >
>
> --
> Message posted via AccessMonster.com
>
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200808/1
>
>
