Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you get information from an Excel Web Query into Access? | Excel Worksheet Functions | |||
With Excel and Word is it possible to merge information together? | Excel Discussion (Misc queries) | |||
Using Excel to manage information in Access | Excel Discussion (Misc queries) | |||
How do I merge excel information with a word document? | New Users to Excel | |||
Sharing information between Access and Excel | Excel Discussion (Misc queries) |