Merge information from Excel to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

xyouareherex - 10 Apr 2008 20:24 GMT

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

--
xyouareherex

Reply to this Message

Ron@Buy - 11 Apr 2008 18:14 GMT

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

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks for the help!

Reply to this Message

Bernie Deitrick - 11 Apr 2008 18:14 GMT

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

> Hi,
>
[quoted text clipped - 14 lines]
>
> Thanks for the help!

Reply to this Message