Merge information from Excel to Access

  • Thread starter Thread starter xyouareherex
  • Start date Start date
X

xyouareherex

Hi,

I am currently an english student living in Québec..

Im working for a company who wants me to use access but I am onl
familiar with excel.

They don`t speak english, and I speak limited french so Im looking t
the internet for a question to be answered.

I am currently typing up information about historic buildings i
Québec, and they want me to make it a database, they havn`t gotte
Access yet so they want me to type it in excel first.

Can you import excel information over into access? or will I have t
retype everything.

Thanks for the help
 
You are there,

Of course you can import Exel data into Access.

When you set up your Excel sheet, enter the column headings into row 1 of the Excel sheet. Use 1
sheet in your workbook for each expected data table for simplicity.

Then, when you have Access, create a new project and use File / Get External Data... / Import... and
select your Excel sheet, and check when it asks if the headings are in row 1. Make sure that you
have a column of unique values that you can use as key numbers,a nd then import each sheet into a
table. The dialog is pretty self-guided.

HTH,
Bernie
MS Excel MVP
 
Back
Top