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!




--
xyouareherex

Merge information from Excel to Access
 

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

Merge information from Excel to Access
 

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