help help help please

  • Thread starter news.cable.ntlworld.com
  • Start date
N

news.cable.ntlworld.com

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
 
A

Andy Wiggins

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help help help please> 1
Microsoft Works to Microsoft Office 6
Browse button for access form 1
help with the cover sheet 1
Help With MS Access 4
Excel Import External Data by Date Automatically 0
Access Making a memo in Access 0
HELP- Excel Spreadsheet onto a Publisher template 1

Top