View Single Post
  #2   Report Post  
Andy Wiggins
 
Posts: n/a
Default

In Access: File Get External Data Import (then) Change "Files of type"
to Microsoft Excel (*.xls), browse to your Excel file, click on Import, then
follow the Wizard's instructions.

BTW, this is an Excel group :-)

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"news.cable.ntlworld.com" wrote in
message ...

Hi All

I need to know how to import excel spreadsheets onto access. My manual

only
covers how to create access databases but at work we will be receiving
information on excel spreadsheets that needs to be imported onto an acess
database. Not sure how this is done

Can anyone please help ??

Cheers

Paul