3 replies
by dklippert
If your Excel data is laid out like you want it to appear in an Access table, there is no problem.
Consider naming the range.
You might also look at linking, so that changes in Access or Excel will be shown in both apps.
Use File>Get external data,
or just copy the Excel data go to Access Tables and just paste the information.
by don_stolzoff
What we require is the ability to 'map' the fields in the excel spreadsheet and copy them into the access db. Not all fileds need to be loaded to the db & we need EXAMPLES of what to do. This is not a 1 to 1 mapping. We are not experts at excel or access, so we need examples, PLEASE.
by hmgeri
Open a new Access Database
click on File... Get external Data... Import.
Then change the Files of type at the bottom of the window that opens to .xls and then find your Excel file. Highlite your file and click on Import.
Click on Next and/or to get to the page which will ask you if you want your headings to follow you over to Access. If you do want them, click the box. You probably will want it in a new table so click that. Click next. This is where you get to skip columns. As you can see it will come up one at a time as you scroll and highlite the fields across the bottom. Click the box for: (Do not Import)skip if you don't want that field. Otherwise leave it alone. Scroll all the way across before you hit next. It then wants to know if you want Access to number your records or if you already have. Up to you. You can always delete.
That should do it. Access will name the table change it to what you want. Good luck!
This discussion is closed to new replies.
Trending Software posts
Sort by Trending