View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default prevent download file assignment to Excel

Hi,

if you mean by assigned that it now has a .xls extension when unzipped, then
you should contact the person who zipped the file and have them save it as a
dbf first and then zip it.

if you mean by assigned that when you double-click the unzipped file it
opens in Excel rather than Access, then you may need to change a file
association.

Of course you can always import it from Excel into Access or copy and paste
it.

You might also consider posting this to the Access newsgroup.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

wrote in message
...
File is received as a zip file and I was able to extract and import
into Access. Something has changed where it is unzipped and assigned
as an Excel file. Prefer it to be dbf. How can I stop it from being
assigned as an Excel?