Importing info from excel into access

  • Thread starter Thread starter Zak
  • Start date Start date
Z

Zak

I have never used Acces before, and I am in desperate need
of advice.

I have a list of over 2000 suppliers and contractors that
I need to put into an Access database. Is there anyway
that the info can be imported without having to type every
entry individually???


anyone, please help!!!!!
 
Zak,

Cheer up, no retyping required! Create a new Access Database, go to meny
File > Get External Data > Import and follow the wizard's instructions to
import your Excel spreadsheet without any typing.

Good Luck!
Nikos
 
create a blank db
click file>get external data>import and follow the wizard
 
File> Get External Data>Import Follow the wizards instructions. Very
simple.

Ed
 
You must log in or register to reply here.

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

Access Importing csv daily files into access 2007 1
Importing information into an access template from excel 2
Add data from Excel to Access 4
Import table info from excel 1
How to export table from outlook into ms access table? 0
Importing Text Files Into Access 1
How can I import a contact list in outlook to access 5
HOW DO I IMPORT NEW DATA FROM EXCEL TO ACCESS FROM EXISTING FILES 1

Back
Top