Merge information from Excel to Access

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 only familiar with excel.

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

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

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

Thanks for the help!

Try lookig he
http://office.microsoft.com/en-us/ac...950951033.aspx
Hope this helps

"xyouareherex" wrote:


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 only
familiar with excel.

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

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

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

Thanks for the help!




--
xyouareherex

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


"xyouareherex" wrote in message
...

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 only
familiar with excel.

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

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

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

Thanks for the help!




--
xyouareherex