Merge information from Excel to Access

[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

 

[Ron@Buy]

Try lookig here:
http://office.microsoft.com/en-us/access/HP010950951033.aspx
Hope this helps

 

[Bernie Deitrick]

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